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
Solved! Go to Solution.
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.
@AdientTP
Hope this works for you