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!!
