Regex-Getting total and subtotal

Help Studio
, ,
1

Hi
I need to get the value of Subtotal from this"Moneda: MXN SubTotal 17,770.00"
and total from this “Total MXN 20,613.20”. Can anyone please help me with the Regex

2

Hi @abivanth.r

(?<=SubTotal\s+).*

image
image990×547 12.3 KB

(?<=Total MXN\s+).*

image
image706×577 11.6 KB

Regards

3

Hi @abivanth.r

image

image

Cheers!!

4

Thanks bro!!
Worked…

1 Like
5

You’re welcome bro @abivanth.r

happy Automation!!

6

Hi @abivanth.r ,

System.Text.RegularExpressions.Regex.Match("Moneda: MXN SubTotal 17,723470.00","[\d,]+\.\d+").Value

This will work for both strings.

Regards,
Vinit Mhatre

7

:heart:
Thanks a lot bro!!!

1 Like
8

Thanks bro!!
working :partying_face:

1 Like
9

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