Add amounts Found using Regex

Hi @spemur01 ,

There are two way to sum up the values, and I have detailed both in this workflow.
Please have a look and let me know if it is as expected.

Single Step →

matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",","")))

Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match)

doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",",""))

MatchandSum.xaml (7.1 KB)

Kind Regards,
Ashwin A.K

2 Likes