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

[mvcarithers]

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!

[fmvizcaino · Accepted solution]

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]

Thank you so much. Worked beautifully. GREATLY APPRECIATED 

[MarqueeCrew · Accepted solution]

@mvcarithers ,

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

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

[fmvizcaino]

Great @mvcarithers !

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

Best,

Fernando V.