About EasyMorph Tutorials & Examples Web-help

Split column into columns


#1

Hi,

I regularly need to split product dimensions from a single column into multiple columns. For example:

Dimensions: 5x10x20

is split into…

Length: 5
Width: 10
Height: 20

I’m currently exporting to Excel and using ‘Text to Columns’, then re-importing into EasyMorph. Is there a way to achieve this in EM so that I can simplify my workflow (i.e., split a column into multiple columns using a delimiter)?

Thanks,

Steve.


#2

Hi Steve,

In version 3.6 we’ve added “Split delimited text” transformation which does the same as “Text to Column” in Excel.

UPDATE


#3

That’s perfect, thanks!!