Removed String Characters

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 🟠
    Accepted 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 Indiana 🔴

    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.

  • That worked!  Thank you s much