How to make [ ] as optional in regex

[Kavya_Mamidishetti2 (Kavya)]

Hi,
I’m new to UiPath and very new to regex.
Need to retrieve values of OnError, Name and Path. Sometimes the values of Name and Path will be in ’ ’ and sometimes in-between ‘[ ]’.

Attaching the Screenshot and text file for your reference.
Thanks in Advance!

sampleText.txt (272 Bytes)

[Palaniyappan (Forum Leader)]

Hi

Hope these expressions will help you in this

If your input is in a string variable named Strinput

Then in a assign activity

Str_OnError = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=OnError=\W).*(?=\WPro)”).ToString

Str_Name = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=Name=\W).*(?=\WPat)”).ToString

Str_Path = System.Text.RegularExpressions.Regex.Match(strinput.ToString,”(?<=Path=\W).*(?=\W\s)”).ToString

Cheers @Kavya_Mamidishetti2

[Kavya_Mamidishetti2 (Kavya)]

@Palaniyappan So I think I can use OR(|) and combine these expressions and convert these values into list.

[Palaniyappan (Forum Leader)]

Fine

In that case

Use like this

List_output = System.Text.RegularExpressions.Regex.Matches(strinput.ToString,”(?<=OnError=\W).(?=\WPro)|(?<=Name=\W).(?=\WPat)|(?<=Path=\W).*(?=\W\s)”).ToList()

Where list_output is a list of string variable

Few * gets disappeared here
So as you said we need to keep a | (or) and mention as matches instead of match @Kavya_Mamidishetti2

Cheers @Kavya_Mamidishetti2

[Kavya_Mamidishetti2 (Kavya)]

@Palaniyappan

strinput

@Palaniyappan Thanks for the response but it is throwing an error though my input is of type String and output variable is of type List(Of string).

[Palaniyappan (Forum Leader)]

Pls try like this

Listoutput = (From a in System.Text.RegularExpressions.Regex.Matches(strinput.ToString,”(?<=OnError=\W). (?=\WPro)|(?<=Name=\W). (?=\WPat)|(?<=Path=\W).*(?=\W\s)”) select Convert.ToString(a)).ToList()

Which is like

Listoutput = (From a in yourexpression select Convert.ToString(a)).ToList()

Cheers @Kavya_Mamidishetti2

[Kavya_Mamidishetti2 (Kavya)]

@Palaniyappan Getting these two values as output

[Palaniyappan (Forum Leader)]

@Palaniyappan

(?<=OnError=\W). (?=\WPro)|(?<=Name=\W). (?=\WPat)|(?<=Path=\W).*(?=\W\s)”

Can I have the text if possible
I can give you the expression

Cheers @Kavya_Mamidishetti2

[ppr (Peter Preuss)]

Regex:
(?<=\bName=‘|\bPath=’|\bOnError=‘)(?:[?{?)(.*?)(?=]?}?’)

And refering to group 1

Kindly note also { } was to handle

In general it is XML and should also be processed with help of XML options / API

[Kavya_Mamidishetti2 (Kavya)]

@Palaniyappan yes sure.
Here it is
sampleText.txt (272 Bytes)

[Kavya_Mamidishetti2 (Kavya)]

@ppr Thanks for the response.It didn’t throw any error and didn’t give any output too as I am assigning your pattern to a list variable.

List_output=System.Text.RegularExpressions.Regex.Matches(strinput,“(?<=\bName=’|\bPath=’|\bOnError=’)(?:[?{?)(.*?)(?=]?}?’)”).Cast(Of Match).Select(Function(n) n.Value.ToString).ToList

[ppr (Peter Preuss)]

@Kavya_Mamidishetti2
Ensure that there is no Copy / Paste issue e.g. for ’ which has to be '

will have a look later on it. Unfortunaltely accesing the group is not implemented in your statement. Can I test later with the string from last text file? Is this sample still valid?

[Kavya_Mamidishetti2 (Kavya)]

@ppr okay.I take care of Copy/Paste issues. You can take the recent text file for reference.

[ppr (Peter Preuss)]

Pattern: "(?<=\bName='|\bPath='|\bOnError=')(?:[\[\{]?)(.*?)(?=\]?\}?')"

[Kavya_Mamidishetti2 (Kavya)]

@ppr Thanks. It is working fine.