Regex Parse

[mystasz]

Hi Community,

I'm having some trouble parsing the attached input. Expected output attached as well. Charles has multiple parses within the same row. 

I'm looking to parse anything before ",ItemBenefitReceived" and after the "| ":

Thank you!

[ChrisTX]

Try

.*\|\s(.*)\,\sItemBenefitReceived*.

the site RegEx101.com helps

[mystasz]

Thank you, that does work. I updated my original discussion to include an example where multiple "items received" exists. If you have suggestions on this, please let me know.

[rickey0830]

Just want to say thanks for posting that site! Been using Rubular, but RegEx101 seems way better!

[PhilipMannering]

Try @ChrisTX 's regex with a couple of question marks in it,

.*?\|\s(.*?)\,\sItemBenefitReceived*.

[mystasz]

This does work, however, it does not work for rows where there are multiple "itemBenefitReceived" items. It parses out 1 but leaves the others. Any suggestions? My expected output is attached. 

[PhilipMannering · Accepted solution]

Hey @mystasz, I see what you mean now.

You want the tokenize method in the Regex Tool. Or you can use a couple of Text-to-Columns Tools. Both are shown in the attached workflow.

[mystasz]

Amazing - thank you. Exactly what was needed.