Regex - Only second monetary value

[aleemendes (Alexandre)]

I need help witha regex code that extracts only the second monetary value, ignoring the first one, as in the example below:

Total de Notas Ativas R$ 135.188,49 R$ 4.506.281,41

I need only the second value.

thanks!

[rlgandu (Rajyalakshmi Gandu)]

@aleemendes

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

System.Text.RegularExpressions.Regex.Match(InputText,"(?<=\d+\sR\$\s+)[\d\.\,]+").Value

[mkankatala (Mahesh Kankatala)]

Hi @aleemendes

You can use the String Manipulations for this to get the second monetary value,

- Assign -> Input = "Total de Notas Ativas R$ 135.188,49 R$ 4.506.281,41"

- Assign -> Output = Input.Split("R$").last.toString.Trim

Check the below result for better understanding,

Or use the below regular expression to get the required output,

- Assign -> Input = "Total de Notas Ativas R$ 135.188,49 R$ 4.506.281,41"

- Assign -> Output = System.Text.RegularExpressions.Regex.Match(Input.toString, "(?<=\R\$.*\R\$\s*)[\d,.]+").Value.toString.Trim

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @aleemendes

Try this

System.Text.RegularExpressions.Regex.Matches(Input.ToString,"(?<=R\$\s+)[\d.,]+").Last.ToString

Regards,

[singh_sumit (Sumit Singh Tariyal)]

Hie @aleemendes you can get the text using string manipulation method here the example hope it help you get your desired output mark this solution if you find it helps you
cheers happy automation

[singh_sumit (Sumit Singh Tariyal)]

@aleemendes

Total de Notas Ativas R$ 135.188,49 R$ 4.506.281,41

and here regex method to get the result