String manipulation - capture x items in list

Hi Community!

I am trying to capture the socioeconomic status with a Get Text activity but I do not know how to manipulate the string to separate and capture the socioeconomic status in the attached image.

Thank you!!

StringManipulationQuestion

Hi,

How about the following steps?

First, Get whole text using GetText activity.

Then, extract text which you need using Regex.Match as the following.

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Socio Economic Data\s+)[\s\S]*?(?=Relationship With Federal Government)").Value

Regards,

Hey @Jessica_Moseley

I have created a xaml which you can use as a starting point.
Essentially I have assumed you have scraped all the text in the screenshot above and then manipulated using Regex to get each line separately.

Check out the xaml here.zip (2.6 KB)

Regex Links:
Regex Pattern 1 - Get all text between Socio Economic Data and Relationship etc…
Regex Pattern 2 - each line becomes a result in a collection

Output Pane in Studio:
image

If you want to learn Regex - check out my Regex Megapost

Hopefully this helps :blush:

Cheers

Steve

1 Like