Find the Dollar amounts between each $ in a series and write to Variables- using Regex Builder

[dgrooves (David)]

Hi all,

I’m having an issue trying to extract each amount after each “$” to variables using Regex.

The values in this string are
Text text text $1,033.53 $1,415.34 $0.00 $1,415.34 $71.73 9. $1,487.07 ANNUAL $2,520.60 text text text
I need to extract 1033.53, the 2nd 1415.34 and 1487.07.
My Regex that I’m using is $\d+.\d{2} and I can only get the first 1033.53 and nothing else. I’ve also tried the Regex builder and this is all I can extract.

2nd Issue when I try and set or assign a Variable I’ve tried to use the expressions DP_VB(0).groups(1).value and I just get System.Text.RegularExpressions.MatchCollection

I’m new to UI Path and any help would be appreciated.

Thanks, David

[rlgandu (Rajyalakshmi Gandu)]

(?<=\$)\d+\,\d+\.\d+

Use this approach hope it helps you

[lrtetala (Lakshman Reddy)]

Hi @dgrooves

Try this

(?<=\$)\d+[.,]?\d+[.,]?\d+

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @dgrooves

You can use the below regular expressions to extract the amounts after $ symbol, Check the below expression,

(?<=\$)[\d,.]+

Check the below image for better understanding,

Hope it helps!!