Splitting cell to columns

[takbb]

Assuming this is what you want to do, it can be done with a java snippet. I’ve added a workflow here using different (but similar) options. The first is a java snippet that converts the column into a string of pipe-delimited characters, and then uses Cell Splitter on that.

The second is based on an even better (and less code) idea from:

Cell splitter for strings

Hi, I would like to split a string into its individual characters. But, Cell splitter node forces me to indicate a delimiter. Is there another way? Thanks,

which is to still use a java snippet but this returns the cell as a String Array column that can then be split using a Split Collection Column.

KNIME_split_cell_to_columns.knwf (27.3 KB)

You will see that to make it portable, without editing code, I’ve packaged up the second snippet as a component which you can also find here:

Cell Character Splitter – takbb