Extract string between two other repeating strings

[Adrian_J]

I have to extract each string between 2 other strings which are “REASON FOR LEAVING” and “ABC COMPANY” but the thing giving me trouble is the 2 other strings repeat. I need to get each string between each repeating 2 strings. How can I accomplish this out of something like below?
SALARY

DUTIES

REASON FOR LEAVING

FROM (MM/DD/YY)

HOURS PER WEEK

SALARY

DUTIES

REASON FOR LEAVING

BECAUSE OF SOME TEST REASON
BECAUSE OF SOME TEST REASON ABC COMPANY HUMAN RESOURCES

EXAMINATION / EMPLOYMENT

SALARY

DUTIES

REASON FOR LEAVING
DIFFERENT TEST REASON

FROM (M/D/Y)

SALARY

DUTIES

REASON FOR LEAVING

ANOTHER TEST REASON
ANOTHER TEST REASON ABC COMPANY HUMAN RESOURCES

EXAMINATION / EMPLOYMENT

[Steven_McKeering]

Welcome @Adrian_J to the UiPath Community

Thank you for the sample text.

Can you tell us/bold the expected output. What else is consistent about the text?

Cheers

Steve

[Adrian_J]

Hi Steve, thanks for replying. The output I’m expecting is to add each string found to a List strExtract for later use as shown below:
strExtract1:
BECAUSE OF SOME TEST REASON
BECAUSE OF SOME TEST REASON

strExtract2:
ANOTHER TEST REASON
ANOTHER TEST REASON

[Steven_McKeering]

Hey @Adrian_J

Thank you for the output. Take a look at this solution I have made. Main.xaml (11.3 KB)

You can preview the regex pattern here.

Check out my Regex MegaPost if you want to learn more.

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…

Hopefully this helps

Cheers

Steve

[Adrian_J]

Thank you so much for this regex help Steven. I couldn’t view the file you attached, it just wouldn’t open for some reason. But I will try to implement the regex from the link you attached and I’ll check out the MEGAPOST too and let you know how it works out for me.

[Steven_McKeering]

Hey @Adrian_J

Okay, lets try another way

Option 1:
Watch this tutorial from Anders Jensen

UiPath | Matches and Regex | Simple and Complete Tutorial

Option 2: Follow my step by step instructions below

Step 1:
Get your variables into their string variables.

Step 2:
Insert a Matches / FInd Matching Patterns activity.

Step 3: Insert your variables from step 1 into the Properties of the Matches activity (top right). See image below.

Step 4: (See image below)
Click into the ‘Result’ field into the properties panel of the matches activity (see the red circle in the top right). Press ‘Ctrl + K’ can call it ‘Matches_Results’.

Step 5:
Insert a ‘For Each’ activity (Green circle).

Step 6:
Insert the variables ‘Matches_Results’ into the For each.

Step 7:
Insert a log message (Purple circle) with the text exactly
"Result: "+currentItem.ToString

Step 8:
Click run and it should work

Hopefully combined you have something to help you out

Cheers

Steve

[Adrian_J]

Thank you so much Steve. This is just what I was looking for!