Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to write a formula for parsing text and numbers, varied data structures

mvcarithers
5 - Atom

Hello!

 

I am trying to write a formula to break out the first part of a text column  from the last part. The data doesn't follow a structure except that the data needs to be parsed from the first integer. 

Currently, this information is all in one column

 

SOD.MIN-Q.CL 12/0,5L  MW
SOD.MIN-Q.MED12/075L  MW
testing       24/0,2L  MW
test-test30X4X6/033L PEW

 

Need the formula to create Column 1, and the remainder of the data in Column 2

Column 1

SOD.MIN-Q.CL

SOD.MIN-Q.MED

testing

test-test

 

Many thanks for any suggestions and your time!

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @mvcarithers ,

 

I'm using the regex tool to separate as you need, the rule I'm using is to identifies everything but a digit in the 1st column.

 

Let me know if that works for you.

Best,

Fernando Vizcaino

mvcarithers
5 - Atom

Thank you so much. Worked beautifully. GREATLY APPRECIATED 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@mvcarithers ,

 

You may want to use a REGEX tool configured to parse the data:

 

capture.png

 

The formula:  

 

(.*?)\s*(\d.*)

 

 

Looks for a group of text followed by a space (or not) then by a group of text starting with a number.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
fmvizcaino
17 - Castor
17 - Castor

Great @mvcarithers !

Please, mark the answer as correct if you feel the answer achieved your expectations.

 

Best,

Fernando V.

Labels