Spread strings to columns

Hi @all,

I have a string with IDs like that (up to 100 IDs):

134-388-389-54-60-88-411-59-398-123-58-53-406-81-418-394-52-52-13

Is there a way to put every ID in a separate Column?

Alternatively: Is there a way to create Columns in Java-Snippet and address these columns via Index to set the value?

Thanks in advance,

Micha.

 

Maybe you could use the row to column node, and perhaps the string manipulation node to obatin proper format of your input string.

Seem's to be pretty difficult, cause I have to parse the input string.

The Result should be like that:


RowID Col#1 Col#2 Col#3 Col#4 …

Line1 134 388 389 54

I've got "row to column node" not to work... But thnx for the hint...

Hi Micha,

you need the cell splitter with '-' as delimiter.

Best, Iris 

Hi Iris,

ok, it wasn't difficult :-)

Your hint works fine...

Thanks a lot!

BW, Michael.

 

PS: In Germany there is an idiom for that situation: "I can't see the forest because of the lots of trees" :-)