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

[rajputakansha]

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?

Field	Output
0,AAA None]||||ABB_BALANCE|90	90
0,AAA None]||||ABB_BALANCE|0	0
0,AAA None]||||ABB_BALANCE|0	0
0,AAA None]||||ABB_BALANCE|80.30	80.3
0,AAA None]||||ABB_BALANCE|0	0
0,AAA None]||||ABB_BALANCE|0	0
0,AAA None]||||ABB_BALANCE|0	0
0,AAA None]||||ABB_BALANCE|9999	9999
0,AAA None]||||ABB_BALANCE|0	0
1463.49,AAA None]||||ABB_BALANCE|1463.49	1463.49
1463.49,AAA None]||||ABB_BALANCE|1463.49	1463.49

Thank you

[smoosh]

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. 

[alisonpitt]

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!

[acarter881]

Hello, @rajputakansha.

Please see the attached workflow.

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