Struggling to split cell

[Yush]

Hi All,

Thanks in advance,

Struggling to split this cell into its components.

[ 413 0 6494]

Want it to be split into 3 columns:

[413], [0], [6494]

Tried the cell splitter node with no success, probably not using it right. See attached workflow.

Thank you,
Yush

KNIME_project4.knwf (6.2 KB)

[kowisoft]

Hi @Yush,

assuming you always have the same amount of numbers in your input, a regex split would help:

([0-9]*) ([0-9]*) (.*)

would do the job.

I have published a short quicktip video here:

KNIME - splitting cell by space (regex)

You can also find the workflow (also using the amazing Palladian extension for testing) at the KNIME hub here:

31892-struggling-to-split-cell – kowisoft

Let us know, if this helped

[ipazin]

Hello @Yush,

seems space you have between numbers is some kind of weird space cause removeChars() doesn’t not remove it. Have you copy pasted this data from somewhere? Cell Splitter works as expected if I manually input data into Table Creator node.

Br,
Ivan

[ipazin]

Hello again @Yush,

seems that is non-breaking space character. How did you get it into KNIME?

Br,
Ivan

[Yush]

Hi,

Sorry for the late reply. I’ve been struggling to get a connection to KNIME forums in recent days. I found this in an Excel file which I imported directly into KNIME. I believe the data in the Excel file was copied from a webpage. Is there any way to deal with this strange non-breaking character in KNIME?

Thanks,
Yush

[ipazin]

Hello @Yush,

yes there is. You can use regexReplace() function from String Manipulation node with following expression to set up you column for Cell Splitter node based on regular space character:
strip( regexReplace( $column1$, "\\u00a0", " ") )

Note: strip() function is only need to remove leading space (and possibly trailing one) after replacement is done.

Also String Replacer node can be used for these tasks. See this topic:

String manipulation node can't remove whitespaces

Hi all, I’ve downloaded a keyword list from Google Search Console, which comes with a column that contains the CTR of each column. Im trying to convert some columns to number, but I have some problems. The number comes in this format: 2,59 % removerchars() function does nothing. If I remover the % symbol first, and then try to remove the white space, its just there, I can’t do anything about it. The only thing that I didn’t try is the regex functions, but no matter if I replace the white spac…

Br,
Ivan