Anyone know how to Remove Texts Before Or After A Specific Character in an ETL? For Example..
remove all characters after "-"
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.
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