Forum Discussion
Split Column - Delimiter Issue
Hello, I have a problem with splitting a column by delimiter. The values within the column look like this "ITEM01, ITEM02, " whih leads in this example to three columns (ITEM01, ITEM02 and an...
Is there any reason as to why you can not split on each occurance and then delete the final column?
Br,
J
I followed your advice but I got the following results:
Example_01:
"ITEM01, " --> [ITEM01] []
Example_02:
"ITEM01, ITEM02, ITEM03, " --> [ITEM01] [ITEM02, ITEM03, ]
I used the following settings:
Anonymous,
ON YOUR QUESTION, IT IS ONLY ITEM1 AND ITEM 2.
HOW YOU WANT TO SPLIT THE ITEMS IN THIS CASE?