How can I remove the words after spaces?

[HKuser]

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!

[HansS]

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

[RedJungleBear]

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