How do I convert a "______" to "NULL" in a string column?

mlauber71 · January 21, 2024, 1:21pm

@Tropicpalm welcome to the KNIME forum.

One option ist the String Manipulation:

regexReplace($column1$, "^ {6}$" ,toNull(""))

Or you can use the Column Expression:

if ( equals(column("column1"), "      "))
{toNull("")}
else {column("column1")}