Splitting columns with custom deliminator

user16290
user16290
in Dataflows

Hi, I'm trying to split my column in my data flow and the data in the original column is formatted as, "Stretch Wrap & Strapping - Copy". I want to split this column such that the "Stretch Wrap & Strapping" is in one column and the other column reads, "Copy". I tried making my custom deliminator, " - " however the split column isnt working... any ideas on how to trouble shoot? Thanks!

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ 🟤
    Answer ✓

    Sorry... you actually want no quotes

     

    just [space]-[space]

     

    It would look like this: - 

     


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Answers

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    Can you try a single quote? 

    ' - ' instead of " - "


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • user16290
    user16290

    That still did not work ?

  • user16290
    user16290

    Thank you so much!

Categories