How to extract decimal number after the $ symbol?

[michaelamay0 (Michael J Amay)]

I have the following text:

Text = “We must receive your first payment of $10.00 soon”

using regex how can i search and retrieve the decimal number after the money symbol?

Thanks.

[Anthony_Humphries]

Assign a string variable to System.Text.RegularExpressions.Regex.Match(MyStr, "(?<=$)(\d+,*)+(\.\d+)*").Value, where MyStr contains your text with the “$” symbol.

[ppr (Peter Preuss)]

@Anthony_Humphries

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

@Anthony_Humphries
Can you check on escaping $ I guess we do need: (?<=\$)(\d+,*)+(\.\d+)*

[michaelamay0 (Michael J Amay)]

None of the above suggestions are working, i get a blank value. Here is my code:

Assign
text = “Thank you for your interest in this product. We must receive your first payment of $2.92 by 3/9/2020. lf you have already made your payment. please disregard this message.”

Assign
currency = System.Text.RegularExpressions.Regex.Match(text, “(?<=$)(\d+,)+(.\d+)”).Value

Write Line
currency.ToString (returns nothing a blank line)

Below is the actual XAML.
_Test - Copy.xaml (5.1 KB)

[Narasimhan (Narasimhan Narayanan)]

You can try this (?<=$)(\d+,)+(.\d+)

[michaelamay0 (Michael J Amay)]

That looks about right but it’s not going through on my code for some reasons. Please look at these screenshots.

[AndersJensen]

You need a ‘?’ after the ‘,’

System.Text.RegularExpressions.Regex.Match(text, “(?<=$)(\d+,?)+(.\d+)*”).Value

[michaelamay0 (Michael J Amay)]

That worked!

Thank you.