Regular expression to extract data line by line

Help
1

Hi

I have some data extracted as below:
How can i write a regex to capture data corresponding to each name?Is there any alternative i can
extract the same?.Here new line is causing me the issue to extract the particular data.

Subscriber Name: xxxxx
SSN or Identification Number: XXXXXXXXX
Employer: xxxxx
Group #: xxxx
Customer #: xxxx
Network: xxxx

2

Could you please upload your workflow with text you are referring?

3

I need Subscriber Name,Employer,Group#,Customer#,Network:

4

Hi,

you can use the Matches activity ans pass the input,pattern to get the list of results

image
image893×136 6.79 KB

for your scenario pattern would be:

“(?sim)\bSubscriber\sName\W(.?$)\sSSN\sor\sIdentification\sNumber\W(.?$)\sEmployer\W(.?$)\sGroup\W(.?$)\sCustomer\W(.?$)\sNetwork\W(.*?$)”

try this and let me know

Thanks,
Meg

5

Hi.
Is this what you are looking for?
System.text.regularexpression.matches(yourstring,“:\s\w*”,System.Text.RegularExpressions.RegexOptions.Multiline)