Parse value in a paragraph

Question

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 Answer

Hey @mzsweetumz,

This setup seems to work:

Regex:

EntitName \|( [^,]+)

Please ask if any questions.

HTH,

Ira