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.
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.
Assign a string variable to System.Text.RegularExpressions.Regex.Match(MyStr, "(?<=$)(\d+,*)+(\.\d+)*").Value
, where MyStr
contains your text with the “$” symbol.
@Anthony_Humphries
Can you check on escaping $ I guess we do need: (?<=\$)(\d+,*)+(\.\d+)*
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)
That looks about right but it’s not going through on my code for some reasons. Please look at these screenshots.
You need a ‘?’ after the ‘,’
System.Text.RegularExpressions.Regex.Match(text, “(?<=$)(\d+,?)+(.\d+)*”).Value
That worked!
Thank you.