Parse value in a paragraph

[mzsweetumz]

Happy Friday all !

I am trying to parse out the name of companies listed in a response (sentence, paragraph) :

Current:

Output:

EntityName: ImmuneSys, Argon Medical Systems Inc, Sirtex Medical Corp, AstrZeneca

I want to parse the name by 'EntityName' in the paragraph above into one row separated by commas as shown in the output.

Any assistance is appreciated!!

Thank you!

[IraWatt · Accepted solution]

Hey @mzsweetumz,

This setup seems to work:

Regex:

EntitName \|( [^,]+)

Please ask if any questions.

HTH,

Ira

[binu_acs]

@mzsweetumz Another way of doing this 

EntityName \| (.+?),