Regex problem : working on regexr.com but not in UI path

[Florent_Delage]

Hello !

I’m very happy to ask my first question… hope that you could help me.

I’m working on a regex to work on this TXT file :

CLASS C ADT=017 CHD=001

NORMAL ADT=017 CHD=001

CLASS M ADT=151 CHD=011 INF=001

NOML ADT=062 CHD=004
VGML ADT=001

My objectives :
I must ignore CLASS… lines and ------------- lines.
I must scrap complete others lines (ex : NORMAL ADT=017 CHD=001 or VGML ADT=001)

I’ve created this REGEX which works on regexr.com…
^(?!CLASS)((?=([a-zA-Z]{4,6}))(.*?)((?<=[a-zA-Z]{3}=[0-9]{3})$|(?<=[a-zA-Z]{3}=[0-9]{3} [a-zA-Z]{3}=[0-9]{3})$))

But when I used it in UI Path, it’s doesn’t works. Maybe it’s related to ^ and $

My declaration on UI path
System.Text.RegularExpressions.Regex.Matches(txtLine,“(?!CLASS)((?=([a-zA-Z]{4,6}))(.*?)((?<=[a-zA-Z]{3}=[0-9a{3})$|(?<=[a-zA-Z]{3}=[0-9]{3} [a-zA-Z]{3}=[0-9]{3})$))”)

Thanks for all help !

[Florent_Delage]

Sorry for bold. I don’t know how to edit my original post

[Yamatendo (Constant Roux)]

Hello,

In your UiPath expression you didn’t put ^ in first, is it desired ?

[Gokul001 (Gokul Balaji)]

Hi @Florent_Delage

Here $ will represent the End of the string

Also ^ will represent the starting of the string

Can you share the sample input and Output

Regards
Gokul

[Yoichi]

Hi,

@Florent_Delage

But when I used it in UI Path, it’s doesn’t works. Maybe it’s related to ^ and $

Can you try Multiline option as the following?

System.Text.RegularExpressions.Regex.Matches(txtLine,"^(?!CLASS)((?=([a-zA-Z]{4,6}))(.*?)((?<=[a-zA-Z]{3}=[0-9]{3})$|(?<=[a-zA-Z]{3}=[0-9]{3} [a-zA-Z]{3}=[0-9]{3})$))",System.Text.RegularExpressions.RegexOptions.Multiline)

Regards,

[Florent_Delage]

Yes,

The complete input

CLASS C ADT=017 CHD=001

NORMAL ADT=017 CHD=001
NORMAL ADT=017 CHD=001

CLASS M ADT=151 CHD=011 INF=001

NOML ADT=062 CHD=004
VGML ADT=001
VLML ADT=001
NORMAL ADT=087 CHD=007

My output on REGEXR :
NORMAL ADT=017 CHD=001
NORMAL ADT=017 CHD=001
NOML ADT=062 CHD=004
VGML ADT=001
VLML ADT=001
NORMAL ADT=087 CHD=007

So maybe in UI Path ^ and $ must be used differently… because when I suppress them, regex works but not as I needed

[Florent_Delage]

I’m trying another approach, line by line… for exemple that one :
NORMAL ADT=017 CHD=001

With this REGEX :
(?![CLASS])(?=[a-zA-Z]{4,6})(.*?)([a-zA-Z]{3}=[0-9]{3}|[a-zA-Z]{3}=[0-9]{3} [a-zA-Z]{3}=[0-9]{3})

On regexr, I get only :
NORMAL ADT=017

I could have for each line NORMAL ADT=0xx CHD=0xx or NORMAL ADT=0xx
Problem come from OR operator, could you tell me I could use it ?
Thanks !

[supermanPunch (Arpan)]

Hi @Florent_Delage ,

Maybe an alternate using String Manipulation can be done in the below way :

String.Join(Environment.NewLine,Split(strText,Environment.NewLine).Where(Function(x) Not(String.IsNullOrWhiteSpace(x) orElse x.Trim.ToUpper.StartsWith("CLASS"))))

Let us know if you are still having issues or provide a feedback.

[Florent_Delage]

I’ve found a more simple solution …
-Split the file into an array
-Iterate on each line by using a more simple regex :
(?![CLASS])(?=([a-zA-Z]{4,6}))(.*?)([a-zA-Z]{3}=[0-9]{3})
-If this regex return results that’s means that I could apply my process : I don’t need to capture the complete line with my regex, for that, I could use the line object.

Thanks for your help !

[jerome_escamilla]

Hello @Florent_Delage make sure to use a .Net Regex Tester so your pattern would work on UiPath. Try this link: .NET Regex Tester - Regex Storm

[Florent_Delage]

Thank you for the link !

[Gokul001 (Gokul Balaji)]

Hi @Florent_Delage

How about this expression

System.Text.RegularExpressions.Regex.Matches(YourString,"^(?!CLASS)\S.+",System.Text.RegularExpressions.RegexOptions.Multiline)

Output

Regards
Gokul