Create dynamic list from delimitted text (dynamic split/dynamic generate list)

rebmanna · April 17, 2020, 6:20am

Hi,
I would like to generate an output list from an delimitted input text (see figure and attached project)
For this I would need a dynamic “generate list”.

The input text can have any separated Elements.

Is there such a transformation?

GenerateTableFromDelimitedText.morph (3.0 KB)

andrew.rybka · April 17, 2020, 10:23am

Hi Adrian,

There is no such transformation.

But you can try to replace separator in the txt_input column with a separator, which definitely will not appear in that column (separator may have several characters), and then use the “Split delimited text into rows” action with that separator. After that, you can rename the column with the “Rename with lookup” action.

dgudkov · April 17, 2020, 10:38am

@rebmanna,

see below an example that uses @andrew.rybka’s recommendations.

GenerateTableFromDelimitedText.morph (4.8 KB)

rebmanna · April 17, 2020, 12:11pm

Hi Dmitry, hi Andrew, great, looks so easy. You just have to figure it out. Thanks to the EM-Heroes