Regex Equation Help

[amruta_George]

Hi,

I have to extract a number from pdf
eg: Organisation Number:123445.
I have to extract the number 123445.I am using “Organisation Number” as reference.But the problem is the number can be of format 123,445 or 123:445 or 12,3:44. And also the reference Organisation Number format also can change like Organisation,Number or Organisation.Number.

In some scenarios this refernce word is not present,in such cases its throwing me an error.If its not present i have to do certain set of actions.How to do that?

How to solve this?

[Gokul001 (Gokul Balaji)]

Hi @amruta_George

You can try with regex expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organisation\sNumber\W)\S+").Tostring

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Output

[amruta_George]

This will work if the reference “Organisation Number” remains like this no.But that also will change like “Organisation,Number” or “Organisation.Number” or “Organisation:Number” .

[Gokul001 (Gokul Balaji)]

Hi @amruta_George

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organisation\WNumber\W)\S+").Tostring

Regards
Gokul

[ppr (Peter)]

@amruta_George
Working with groups may can help:

We turned on caseinsentive option and refert to groups

((Organisation.?)?(Number.?)?(.*?))\b([\d,.:]+)\b

Immediate panel prototyping:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

[Gokul_Jayakumar (Gokul Jai)]

@amruta_George

format 123,445 or 123:445 or 12,3:44. And also the reference Organisation Number format also can change like Organisation,Number or Organisation.Number.

Hello @amruta_George
Try this regex Expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organisation\WNumber\W)[\d\W]+").Tostring

[Sudharsan_Ka]

Hi @amruta_George

You can also try this

"Organisation Number:123445".Substring("Organisation Number:123445".IndexOf("Organisation Number:")+"Organisation Number:".Length).Split(Environment.NewLine.ToCharArray)(0)

Instead of this “Organisation Number:123445” use your str variable

Note: While Readin the PDF make sure to update the property of Preserve Formatting to “True”

Regards
Sudharsan

[amruta_George]

This will work if there is mandatory comma or space or anything…Sometimes it can also come as “OrganisationNumber”. Then this will not work.

[ptrobot]

(?<=Organisation\W?Number\W)[\d\W]+

[Gokul001 (Gokul Balaji)]

Hi @amruta_George

If possible just share the input format

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organisation\WNumber\W)\S+|(?<=OrganisationNumber\W)\S+").Tostring

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

@amruta_George

This will work if there is mandatory comma or space or anything…Sometimes it can also come as “OrganisationNumber”. Then this will not work.

@amruta_George ,
Try this
(?<=Organisation\WNumber\W)[\d\W]+|(?<=OrganisationNumber\W)[\d\W]+

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Organisation\WNumber\W)[\d\W]+|(?<=OrganisationNumber\W)[\d\W]+").ToString.Trim