How to use Regex function to extract numbers(with decimals) from a string?

Question

Hello,

I have a scenario where I need extract amounts from a string. This could be achieved either by using regex function or pulling amounts from the end of the strings.

Can someone suggest a dynamic solution to this problem?

FieldOutput0,AAA None]||||ABB_BALANCE|90900,AAA None]||||ABB_BALANCE|000,AAA None]||||ABB_BALANCE|000,AAA None]||||ABB_BALANCE|80.3080.30,AAA None]||||ABB_BALANCE|000,AAA None]||||ABB_BALANCE|000,AAA None]||||ABB_BALANCE|000,AAA None]||||ABB_BALANCE|999999990,AAA None]||||ABB_BALANCE|001463.49,AAA None]||||ABB_BALANCE|1463.491463.491463.49,AAA None]||||ABB_BALANCE|1463.491463.49

Thank you

acarter881 · Answer

Hello, @rajputakansha.

Please see the attached workflow.

I believe this RegEx will work for you: ([^|]*)$.

After Rightmost Pipeline.yxmd

alisonpitt · Answer

I'd go with parsing using this expression: .*\|(.*)$. That'll just grab everything between the last "|" and the end of the string.

I second the recommendation for regex101.com - it's the best resource for learning and testing regex!

regexend.yxmd

smoosh · Answer

I'm sure someone will post a better answer, but give the attached workflow a shot. It works correctly on your sample data.

Also, I find this site a great resource for playing with RegEx, and getting a better understanding of what it's doing and why.

https://regex101.com/

Good luck.

RegEx.yxmd