Removed String Characters



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



remove all characters after "-"




Best Answer

  • MichelleH
    MichelleH 🟣
    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


  • 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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • That worked!  Thank you s much