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
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.
Good luck.
Hello, @rajputakansha.
Please see the attached workflow.
I believe this RegEx will work for you: ([^|]*)$.