Splitting columns with custom deliminator

user16290
user16290
in Magic ETL

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-_ Coach
    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-_ Coach

    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 ?

  • ST_-Superman-_
    ST_-Superman-_ Coach
    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
  • user16290
    user16290

    Thank you so much!

Categories