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:
Is there any reason as to why you can not split on each occurance and then delete the final column?
Br,
J
After the second try, your suggestion worked.
Thanks!
There are also cells without an item and therefore without a delimiter.
Is there a way to cut off the last two characters?
Then I could do this and then split as usual.