Hi All,
I have bunch text strings want to use text to column and split into 2 columns. Any good ideas on tackle this? Thanks.
Sample Text String:
Argentina-$225Colombia-$300Greece-$7000Italy-$3750Qatar-$3250Russia-$360SaudiArabia-$1350SouthAfrica-$225Spain-$510Sweden-$5000UAEMainland-$45UnitedStates$200 |
Ideal output:
Country | Pricing |
Argentina | 225 |
Colombia | 300 |
Greece | 7000 |
Italy | 3750 |
Qatar | 3250 |
Russia | 360 |
SaudiArabia | 1350 |
SouthAfrica | 225 |
Spain | 510 |
Sweden | 5000 |
UAEMainland | 45 |
UnitedStates | 200 |
Solved! Go to Solution.
Hey @BosKev
I used some quick RegEx to split the data into rows in place of the Text to Columns tool. The RegEx piece is basically a way to match the string you want to put into each row. So my RegEx string is
\w+-\$\d+
Those symbols stand for: match a bunch of letters, followed by a hyphen, followed by a $ sign and then any number of digits. I recommend https://regex101.com/ as a good resource for testing and understanding RegEx along with some of our live trainings like this one: https://community.alteryx.com/t5/Videos/Parsing-with-Regular-Expressions/td-p/48576
Let me know if this helps!
-Chris
Thanks Chris, I will look into regex more since 60% of my time is spending on cleaning up messy data.