Excel text to column equivalent in magic ETL

Chips · April 2016

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

jehat · May 2016

Since Magic ETL is still in beta, there is not currently an easy function to simulate the "text to columns" functionality that exists in Excel. However, if you use a MySQL dataflow, you can take advantage of the "substring_index" function, which provides similar (although not exactly the same) functionality.

You can learn more about SUBSTRING_INDEX() here: http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php

czmudzinski · May 2016

This link works:

http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php

(the above poster's ending period got pulled into the URL)

kshah008 · April 2016

Hi all,

Can anybody help @Chips with their question?

Thanks!

moniP · April 2016

I am also interested to know as well!

jehat · May 2016

Since Magic ETL is still in beta, there is not currently an easy function to simulate the "text to columns" functionality that exists in Excel. However, if you use a MySQL dataflow, you can take advantage of the "substring_index" function, which provides similar (although not exactly the same) functionality.

You can learn more about SUBSTRING_INDEX() here: http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php

moniP · May 2016

I am interestedi n this too, however i see a 404 error on this page

czmudzinski · May 2016

This link works:

http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php

(the above poster's ending period got pulled into the URL)

kshah008 · May 2016

@Chips, did any of the above replies help you out?

RobynLinden · February 2017

Has this functionality been developed since the original post? Either in ETL or Beast Mode? I'm looking for this solution as well.

JennFoster · March 2017

I am also curious is this is something that is now available in ETL and if so, how to perform it?

Thanks!

[Deleted User] · March 2017

@btm please chime in on this one.

Thanks!

AndreaChapman · June 2017

This worked perfectly!! Helped to solve my problem! Thanks for providing the link!

coEvaNes · July 2019

Since this post has been solved with MySQL dataflow for a while, is there any updates on the Text to Column feature using ETL? (I am new to ETL, so if this has been solved in other places, please advise.)

Excel text to column equivalent in magic ETL

Best Answers

Answers

Categories