I have a column in my data set that displays the data in the following format, per record:
With each section separated by the character, "|". Also, each category (1-6) is not a consistent character length, so I can't just do a formula to cut x-characters from the right, sadly.
My goal is to split each category into its own column.
I think the RegEx tool may be what I need to use, but I am not familiar with how to write an expression that would be able to do this. I've tried a few examples that I've found, but can't get them to work.
Thank you for your help and please let me know if you need any clarification.