Excel text to column equivalent in magic ETL

Chips

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

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

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

Hi all,

 

Can anybody help @Chips with their question?

Thanks!

moniP

I am also interested to know as well!

jehat

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

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

czmudzinski

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

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

RobynLinden

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

JennFoster

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

 

Thanks!

[Deleted User]

@btm please chime in on this one.

Thanks!

AndreaChapman

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

coEvaNes

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