How to subtract two values with same name


How extract sub total left side and minus from the sub total right side. Could you provide any solution

Thanks in advance .


Do you have the above data as String? If so, the following will work.

mc = System.Text.RegularExpressions.Regex.Matches(yourString,"(?<=Sub Total\s*)[.\d]+")

Sequence.xaml (5.8 KB)


1 Like

Hi @Yoichi ,Yes above one is string .
Thank you so much

Hello @Suggala_Tejaswi

After reading the file what is the data that you are getting? Can you share that here?

You can use either regex or a combination of split to get the data and you need to convert to interger for doing the calculation.


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.