Regex issue at having parenthesis

[Angel_Llull (Angel95)]

Hi all,

I am having an issue related to regex at reading pdfs:

I want to get the name of car. From Sportage or Kia until the last character before the amount. The issue is that sometimes there is “(MYXX)” and if I put the following code, it gets all you can see:

(?<=^\w{17}\s+)[\w.-,\s]+[\s(\w)]+

How could I do it?

Thanks

[Yoichi]

Hi,

Can you try the following pattern?

(Sportage|KIA).+?\(.*?\)

or

(?<=[A-Z0-9]{17}\s).+?\(.*?\)

Regards,

[Angel_Llull (Angel95)]

Thanks @Yoichi!! Could you explain me what is it doing “.+?(.*?)”? As it is first time I see it
Many thanks!!

[Yoichi]

Hi,

.+?\(.*?\)

In this case, ? means lazy quantifier. Please check the following document.

Quantifiers in Regular Expressions

And \ is for escaping parenthesis.

Regards,

[Angel_Llull (Angel95)]

Hello,

I am doing this regex code, and it works in regexr.com but in Uipath the output is empty, and I have activated multiline option:

UiPath: system.Text.RegularExpressions.Regex.Match(pdf, “(?<=^\d{6,}\s[*,\w,\s,,]+[\d,,.]+\s[\d,,.]+\s\w\s[\d,,.]+\s(.*?))[\d,,]+$”, RegexOptions.Multiline).Value.ToString

Do you know why is empty in UiPath?

Thanks

[Yoichi]

Hi,

It might be line break matter.

Can you add \r? at the end of the pattern as the following?

[\d,\,]+\r?$

Regards,

[Angel_Llull (Angel95)]

Perfect! It works