How to subtract two values with same name

[Suggala_Tejaswi]

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

Thanks in advance .

[Yoichi]

Hi,

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)

Regards,

[Suggala_Tejaswi]

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

[Rahul_Unnikrishnan]

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.

Convert.ToInt32(“StringVal”)