Split delimited Text into Columns - SplitCount by Parameter

Feature requests
1

For XML editing, it would be great to be able to specify the split depth with a parameter or the value of a column:

This would make the number of columns dynamic:

image
image352×450 35.7 KB

Example:
Here the parameter would be the column "Level" or the expression substringcount([Column Name],'/')

image
image670×761 115 KB

Result:
Instead of the fixed column names, the columns would then be called SplitColumn_1 to SpliutColumn_n.

image
image755×694 70.4 KB

Would this feature be possible?

regards,

Adrian

1 Like
2

Hi,

Does this fill your needs ?
make it a module and call it when required.
Don't forget to change the root XML path regarding imported files.

Regards

xml_json_extract.morph (211.4 KB)

3

Hi,

t works ... great ... Thanks :slight_smile:

regards,

Adrian

4

I'm glad it helps you.
Set a parameter for the root XML path and make it a module that you can call from any projet.
It works with json and shared memory also.

One of EasyMorph's strengths is its ability to handle transformations on both data and metadata.
This is a typical use case.

Regards