Hi everyone,
I'm trying to parse a set of data that has the Account Description in this format:
Car Parking Sales (Cash) (105)
Project Expense (External) (104.2)
Transportation - Others (Deployment) (444.95)
I want to parse it to separate the text details (including "-") from the number in parenthesis.
Could you please help?
Solved! Go to Solution.
There might be a cleaner way, but this works ....
([a-zA-Z\ \(\)\-]*)(\d*\.*\d*)
Hi @minniiko,
My suggestion would be (.+)\s\((\d+.*\d+)\)
Hope this helps.
Cheers,
Lelia
This works like a charm!!! Thank you both so much! Cheers!