Regex for extracting string

Help Studio
,
1

Hi UiPath,

let say I have 2 possibles strings below:

10-77349_PLS LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU

or

10-77349_PLEASE LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU

How can I manipulate it to have the output format below:

10-77349_APR&RETAILS

2 Likes
2
  1. Use the Assign activity to manipulate the string and store the desired output in a new string variable, let’s call it outputString. Here’s an example of the assignment:

scssCopy code

outputString = System.Text.RegularExpressions.Regex.Match(inputString, "(\d{2}-\d{5})_.*?_([A-Z]{3}&[A-Z]{7})").Groups(1).Value + "_" + System.Text.RegularExpressions.Regex.Match(inputString, "(\d{2}-\d{5})_.*?_([A-Z]{3}&[A-Z]{7})").Groups(2).Value

In this example, the regular expression pattern (\d{2}-\d{5})_.*?_([A-Z]{3}&[A-Z]{7}) is used to match and capture the desired parts of the input string. The first captured group (Groups(1)) represents the “10-77349” part, and the second captured group (Groups(2)) represents the “APR&RETAILS” part. The + operator is used to concatenate the captured groups with the “_” separator.

After executing this Assign activity, the outputString variable will contain the desired formatted output: “10-77349_APR&RETAILS”.

3

Follow the below Regex Expression:

([\d-]+_+)|((?<=#_)[\w&]+)

image
image1430Ă—502 20.2 KB

Hope it helps!!
Regards,

4

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(yourString,"(^[-\d]+).*?PO#_([^.]+).*","$1_$2")

Regards,

5

Hi

thanks for everyone’s effort in answering my question.

Let say I just want to extract the last one below?

image
image787Ă—57 6.59 KB

APR&RETAILS is dynamic string

Hope to hear from you guys soon

6

Hi @alvin.c.apostol26
Try using the below Regex expression:

((?<=#_)[\w&]+)

image
image1434Ă—511 19.7 KB

Hope it helps!!
Regards,

7

Hi @alvin.c.apostol26

Use the below regex expression for the output.

image
image787Ă—331 20 KB

Hope it helps!!

8

Hi,

My first expression will work because it doesn’t contain ARP&RETAILS in the pattern.

System.Text.RegularExpressions.Regex.Replace(yourString,"(^[-\d]+).*?PO#_([^.]+).*","$1_$2")

Regards,

9

@alvin.c.apostol26

Try this:
(?<=PO#_)[^.^\s]+

It uses PO#_ as point of reference instead of just # and also takes the whole string until it hits a . or a space.

image
image838Ă—392 29.2 KB

Thanks

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.