How can I remove the words after spaces?

For my case,

123456 hoisdjfo
238472398 df0-giclkb
1231298 djfgoijdfoi
2309482905809s oidfgjoi
234209 sdkjfsoidg

How can I remove the words after spaces?

Thx a lot!

Hi @HKuser and welcome to the Forum

There are multiple ways in KNIME. You can use e.g. Cell Splitter node, and use the spaces as a delimiter.

gr. Hans

5 Likes

You can also use the String Manipulation node - this expression should work: “substr($column1$,0,indexOf($column1$,” “,0))”

4 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.