What is the equivalent of the text to columns (from Excel) function in magic ETL? I have a column with mixed values that I need dileneated based on a constant character (in this case ";").
Ex.
123456;SKUName
Need two columns
Column A Column B
123456 SKUName