HOW TO DELIMITERS IN SERIAL NUMBER

[adha_dastu]

Hello guys,
i have a column one column and i want to split but the column have a serial number like
1sgts2ayada
2shjs3wd
3mnsad
… till 1000xxxx

and i want to output like this
1 sgts2ayada
2 shjs3wd
3 mnsad
…
1000 xxxx

[ipazin]

Hello @adha_dastu,

and welcome to KNIME Community!

If you always have numbers at the begging followed by letters you can use regular expression. Try this expressions out in Regex Split node:
(\d+)(.*)

Br,
Ivan

[sanket_2012]

Hi @adha_dastu ,
Welcome to the KNIME Community!

You can try to use the Cell Splitter by position node to separate the serial number.

Thanks,
Sanket