One column to many

[CSchimm]

Hi All!

I have a column of data that is formatted like below:

One random set of words + 0.01 USD/gal + A different set of words - 0.054 USD/gal

A third set of random words - 0.0225 USD/gal + A fourth set of words + 0.0105 USD/gal

I am trying to separate this one column into 4 separate columns while retaining the sign on each of the numbers.

Column1                                       

One random set of words

A third set of random words

Column 2

+0.01

-0.0225

Column 3

A different set of words

A fourth set of words

Column 4

- 0.054

+ 0.0105

I am certain using RegEx and parse or another set of tools would make this possible, but I just get so confused with all the symbols and am still relatively new to Alteryx. The community's expertise would be super appreciated right now!

Thanks!!

[ShankerV · Accepted solution]

Hi @CSchimm 

One way of doing this.

[ChrisTX]

The website regex101.com helps test regular expressions.

Try this expression in a RegEx tool in Parse mode:  

(.*?)([+-]\s\d\.\d{2,})(.*?)\s([+-]\s\d\.\d{2,}).*

Chris

[CSchimm]

So very helpful! Thank you!