This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Only because you mentioned RegEx as a solution, I figured I would offer up an option (Although I agree it's a bit overkill).
The simplest method is RegEx Tokenize. All you would need in the Regular Expression is "\w+". Set your Properties to either the number of columns (if your string is consistent) or rows, if it can be inconsistent length.
Note, this assumes that you have no non-word characters in your categories. If you do, then you would have to modify the regex pattern.