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)?
Maybe I am not using the transformation not correct but it would be nice if this transformation could deal with variability in the number of elements in a delimited text string.
If for row 1 you have for instance: 5x10x10 ( = 3 elements in the string) and in row 2: 5 x10x20x30 (4 elements), EasyMorph does not create the 4 columns automatically.
Could you add this feature or can we use a workaround in the current version ?
i have a similar problem.
The source data comes as XML with previously indefinable structure depth.
In the target table, the name of the column should be the last name in the structure.
So by example the name of the column Slashcout + 1 or the “split delimited text into columns” Action should keep the last column.