Parsing all data before a number

[AdientTP]

Hi all,

I receive a file and it contains a column called "Allocated Total".  This column has both the amount and currency in the same field.  I would like to separate the currency identifier from the amount into two separate columns and then change some of the currency codes so that i can use for exchange rates.  

Allocated total

$66,002.02

€28,587.03

₹920,889.00

MXN223,213.14

LSL66,764.78

MKD133,323.00

PLN9,175.93

£1,692.00

CZK50,747.60

€1,794.62

RON8,173.44

â.¹ is INR (Indian Rupee)

â,¬ is EUR

£ is GBP

I am relatively new to Alteryx but am preparing for the core qualification so the regex tool was a tool too far. 🙂

Any help much appreciated.

Keep up the good work.

Martin

[afv2688 · Accepted solution]

Hello @AdientTP ,

how about this?

Regards

[Emil_Kos]

Hi @AdientTP,

I needed to use two finds and replace tool as the regex formula that I have used didn't work for ¹

Thie is the workflow:

Output:

The regex will remove all the data from before the first number

I stole it from @MarqueeCrew I hope he will don't mind. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stripping-out-Text-before-a-number-kee...

[Qiu]

@AdientTP 
Hope this works for you

[MarqueeCrew]

No worries @Emil_Kos !