How to split large string to get specific element

Hi guys,

I need to fetch only a specific string in the given below image.
Here am doing screen scraping and using for each loop where in each item am getting a large string(given below) which is uneven. I need only ‘Adams, Julie’ (referring to first image ) and ‘Mallouk-PM2,Peter’( referring second image)

image

image

1 Like

You can use regular expression for Name and based on that you can split string on behalf of all String.

Check this link definitely you will get your answer

you can use matches activity to get the required field by using this pattern (?<=Exec).*

Cheers

1 Like

Hello @Vinutha_L

I have another solution. Try this pattern:
(?<=Exec\s+)\b[^,]+,\s+[\w\d-]+

Hopefully this helps :blush:

If you want to Learn Regex - Check out my Regex Megapost :smiley:

2 Likes

Hey @Steven_McKeering

Thanks a ton!! its working perfectly. :heart_eyes:

2 Likes

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