Regex example

[EN6924]

I wanted to extract the amount info from the input -

How can I achieve that adding applying a loop?

Note: Records having no amount will be blank in result as shown above.

Please help.

[Qiu]

@EN6924 
Can you give your expected output?
I am a bit confused.

[EN6924]

@Qiu 

Output has been already generated. The 'Amount' column is my output.

Wanted to know if this can be done in more short way.

[Qiu · Accepted solution]

@EN6924 
Not really shorter. just made the regex shorter. 😁

[EN6924]

Great 😮 Thank you very much 😊

[Qiu]

@EN6924 
Glad to help and thank you for accepting my anwser. 😁

[binuacs · Accepted solution]

@EN6924 another way using Regex Tokenize method

.*(\$\d+\W\w\S+)