I want to get Work request number and ticket number using regex. please help

[Puneet_Singh3 (Puneet Singh)]

You have been awarded Work Request : 05958891.
Ticket Number : CNR2208169.
Please consult the ACAS System for details.

[ppr (Peter Preuss)]

we can anchor the regex

similar we can do for the ticket

[Puneet_Singh3 (Puneet Singh)]

System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<= Work Request:)”/d+).Value
but its showing error.

[ppr (Peter Preuss)]

you are not using backslash d and also do end the string quotation not on end of pattern string

Please use the right syntax as shown above

[Puneet_Singh3 (Puneet Singh)]

Sorry for bothering. Please correct me with correct syntax
System.Text.RegularExpressions.Regex.Match(MailSubject,"(?<=Work Request:)(\d+,*).Value.ToString

Thanks in advance

[ppr (Peter Preuss)]

(?<=Work Request : )\d+

System.Text.RegularExpressions.Regex.Match(YourStringVar,"(?<=Work Request : )\d+").Value.ToString

[Gokul001 (Gokul Balaji)]

Hi @Puneet_Singh3

Here is the expression for Work Request

regex101: build, test, and debug regex

Use Assign Activity
LHS - Create an avriable
RHS - System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<=Work Request : )\d+”).Tostring

Here is the expression for Ticket Number

regex101: build, test, and debug regex

Use Assign Activity
LHS - Create an avriable
RHS - System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<=Ticket Number : )\w+”).Tostring

For More Information Refer the thread

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Regards
Gokul

[Puneet_Singh3 (Puneet Singh)]

Getting Blank in message box

[Gokul001 (Gokul Balaji)]

Can you share the Exact Input in preserver format @Puneet_Singh3

[Gokul001 (Gokul Balaji)]

Hi @Puneet_Singh3

Here is the expression for Work Request

Try this expression

regex101: build, test, and debug regex

Use Assign Activity
LHS - Create an avriable
RHS - System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<=Work Request)\s+\d+”).Tostring.Trim

Here is the expression for Ticket Number

Try this expression

regex101: build, test, and debug regex

Use Assign Activity
LHS - Create an variable
RHS - System.Text.RegularExpressions.Regex.Match(MailSubject,“((?<=Ticket#)\s+\w+”).Tostring.Trim

Regards
Gokul

[Puneet_Singh3 (Puneet Singh)]

Work Request is working fine but getting issue in Ticket on Issue is ""Assign: parsing “((?<=Ticket#)\s+\w+” - Not enough )'s.

String is You have been awarded Work Request 05958948, Ticket# CSR2209549. Please consult the ACAS System for details.

[Gokul001 (Gokul Balaji)]

Hi @Puneet_Singh3

Try this expression

Use Assign Activity
LHS - Create an variable
RHS - System.Text.RegularExpressions.Regex.Match(MailSubject,“(?<=Ticket#)\s+\S+”).Tostring.Trim

Regards
Gokul