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!
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.
Try
.*\|\s(.*)\,\sItemBenefitReceived*.
the site RegEx101.com helps
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.
Try @ChrisTX 's regex with a couple of question marks in it,
.*?\|\s(.*?)\,\sItemBenefitReceived*.
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.
Amazing - thank you. Exactly what was needed.
