Separate name and last name – KNIME Community Hub

This is a companion discussion topic for the original entry at

Hi everyone,

I am new to KNIME and need advice to split NAME column into FIRST NAME and LAST NAME.

I have seen the previous information on this post and do not understand and create that in my KNIME Workspace.

To give more information, i have attached the PPT below.

Please advise.

SplitName.pptx (176.6 KB)


Hi @Johnseng and welcome to the KNIME community.

Assuming that your data is always first name and last name separated by a space, then there are several ways it can be achieved, such as using Regex Split, Cell Splitter, a pair of String Manipulation nodes or a Column Expressions node (and there are other script-based options too using Java for example). It really depends on which you feel most comfortable with.

I suggest you take a look at one or more of those options and see how you get on. If you are really struggling then post a sample workflow explaining the problem you are having and maybe we can give you further pointers.

1 Like

Hi @takbb,

Thanks for the guidance. The Cell Splitter node works for me.
I am able to proceed to the next stage of my task now.


1 Like