Forum Discussion
Split Column - Delimiter Issue
Is there any reason as to why you can not split on each occurance and then delete the final column?
Br,
J
Anonymous ,
Refer below screen shot: Select Left most Occurence in Split column option.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
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,
JAfter 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.
Anonymous ,
How many Items do you have? if it is upto Item3 so use below screen shot and respected output:
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
Anonymous,
ON YOUR QUESTION, IT IS ONLY ITEM1 AND ITEM 2.
HOW YOU WANT TO SPLIT THE ITEMS IN THIS CASE?
