Regex uipath

[chiru74 (Chiranjeevi)]

Hi Team,

I have a text as mentioned below:
9,202.02
Due Date: TAX INVOICE
TOTAL DUE
140,659.47
30.OCT.2019

I have to read the amount below to the “Total Due” field from the text file. I’m using Regex as below:

System.Text.RegularExpressions.Regex.Match(Result,“(?<=(Total Due))\d+\s:(.*)(?=\s)”).Value

This is returning an empty field. Ant help please?

[Pablito (Pawel Wozniak)]

Hi @chiru74,
Remember that regex might be case sensitive. In your expression there is to much brackets if I see correctly. Try this instead:
(?<=TOTAL DUE)\n[[:graph:]]+

[dmccammond (Derek McCammond)]

I would suggest trying to build regex patterns using a tester. I have found this one to be helpful because it actually has the .net language: .NET Regex Tester - Regex Storm

Just putting something together really quickly, I came up with: TOTAL DUE\r\n([\d,\.]+)

Here’s how it looks:

[dmccammond (Derek McCammond)]

Please don’t use regex101.com for UiPath. That does not have the .net language and any regex’s tested may not work as .net is dumb and does not have nearly as many features as other languages.

If you test that using .net, that does’t give anything:

[chiru74 (Chiranjeevi)]

@dmccammond

TOTAL DUE\r\n([\d,\.]+)

Thanks for the reply…But I’m getting result as

TOTAL DUE
140,659.47

But the output I need is

140,659.47

Could you please suggest on this?

Thanks again

[dmccammond (Derek McCammond)]

Are you using the match group?

You have to pull out the portion that was captured. If you just look at the match text, it will give you the whole match like you’re showing.

[kadiravan_kalidoss (Kadiravan K)]

@chiru74

System.Text.RegularExpressions.Regex.Match(Result,“(?<=(Total Due))\d+\s:(.*)(?=\s)”).Value

regexBetweenLabel.xaml (5.5 KB)

System.Text.RegularExpressions.Regex.Match(strInput,“(?<=TOTAL DUE)([\S\s]*)(?=(\d{2}.\w{3}.\d{4}))”).Value.Trim

Thanks!

[Pablito (Pawel Wozniak)]

@dmccammond,
You’re right about that. I totally forgot .net case. Thanks for being watchful