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!
Solved! Go to Solution.
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.
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.
Hey @MysticalAz, 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.
Amazing - thank you. Exactly what was needed.