Removed String Characters

Options
nj-John-mirc
nj-John-mirc Member
in Magic ETL

Hi

 

Anyone know how to Remove Texts Before Or After A Specific Character in an ETL?  For Example..

"yankeeswillwin-theworldseries"

 

remove all characters after "-"

 

Thx

John

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    MagicETL has a "Split Columns" tile in the Edit Columns section made specifically for this purpose. You can specify a delimiter, in your case "-", and it will create separate columns for text that occurs before and after the delimiter. You can also make as many splits you want, as long as the delimiter is the same.

     

    Split Columns.PNG

Answers

  • GrantSmith
    GrantSmith Coach

    Hi @nj-John-mirc 

    Depending on how many dashes you have and if that number will be consistent you can utilize the Split Column tile and split on a custom character '-' to get the different parts of your value.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MichelleH
    MichelleH Coach
    Answer ✓

    MagicETL has a "Split Columns" tile in the Edit Columns section made specifically for this purpose. You can specify a delimiter, in your case "-", and it will create separate columns for text that occurs before and after the delimiter. You can also make as many splits you want, as long as the delimiter is the same.

     

    Split Columns.PNG

  • nj-John-mirc
    nj-John-mirc Member

    That worked!  Thank you s much

Categories