Text to columns split to rows

[BosKev]

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

[ChrisHe · Accepted 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

[BosKev]

Thanks Chris, I will look into regex more since 60% of my time is spending on cleaning up messy data.