Regex to extract money including the dollar sign

[AhmedKutraphali]

Input sample : Balance $2,581,505.60
Output : $2,581,505.60

Current implementation : System.Text.RegularExpressions.Regex.Matches(“Balance $2,581,505.60”, “\d+(.\d+)*”)

Any help would be appreciated thanks.

[AhmedKutraphali]

Appreciated.

[ppr (Peter)]

@AhmedKutraphali
have a look here:

[Steven_McKeering]

Hello @AhmedKutraphali

Try this pattern:
(?<=Balance\s)[\d,.$]+

http://regexstorm.net/tester?p=(%3F<%3DBalance\s)[\d%2C.\%24]%2B&i=Input+sample+%3A+Balance+%242%2C581%2C505.60

Hopefully this helps

[AhmedKutraphali]

@Steven_McKeering Since there is only one ouput that I expect from the regex match , how do we directly get the value without looping on the output matches ? thanks.

[AhmedKutraphali]

I tried out_put(0).ToString but it gives an error objbject reference not set to an instance of an object

[prasath17 (Guru)]

@AhmedKutraphali - Try like this…

StrOutput variable type is MatchCollection

[AhmedKutraphali]

why do i get Throw: Error Occured :Object reference not set to an instance of an object.?

[prasath17 (Guru)]

@AhmedKutraphali - Could you please share what you have tried?

[AhmedKutraphali]

@Steven_McKeering

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

Throw: Error OccuredError Occured :Specified argument was out of the range of valid values.
Parameter name: i

[prasath17 (Guru)]

@AhmedKutraphali - Please find the starter help here… Main.xaml (5.3 KB)

[AhmedKutraphali]

Still the same , this is the sample output from the variable

Balance I
$2,581,505.60

[AhmedKutraphali]

i tried your regex on the regex build it does not highlight or even work @prasath17 @Steven_McKeering Thanks

[prasath17 (Guru)]

@AhmedKutraphali - Test text is not the output…You completely messed up…I have already provided the Regex with Code…if you want Matches activity i can share a sample…

[AhmedKutraphali]

@AhmedKutraphali

Balance I
$2,581,505.60

Try this format , thanks

Balance I
$2,581,505.60

[AhmedKutraphali]

@Steven_McKeering

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

the format above is multi line

[prasath17 (Guru)]

@AhmedKutraphali - Main_1.xaml (6.6 KB) – Check this.

You initially gave one input , now your input is completely different . That’s why Regex had returned empty result. Please share the correct/Proper input so that we will give correct solution.

[Yoichi]

Hi,

I suppose the following is better in this case, FYI.

System.Text.RegularExpressions.Regex.Matches(yourString, "(?<=Balance[\s\S]*?)\$[.,\d]+")

Regards,

[NIVED_NAMBIAR (NIVED N)]

Hi @AhmedKutraphali

U can use

output_var.ElementAt(0).ToString

Where output_var is the output of regex matches

Regards

Nived N

Happy Automation