Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 empty one). How can I make it to only get two columns (ITEM01 and ITEM02)

 

 

Thanks for your help 🙂

Need Help
  • tex628's avatar
    tex628
    6 years ago

    Is there any reason as to why you can not split on each occurance and then delete the final column?

    Br,
    J

8 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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:

       

       
      • tex628's avatar
        tex628
        Community Champion
        6 years ago

        Is there any reason as to why you can not split on each occurance and then delete the final column?

        Br,
        J