Icon

String insert NULL - KNIME Forum (76691)

Remove 6 blanks and replace them with NULL
Remove 6 blanks and replace them with NULL

https://forum.knime.com/t/how-do-i-convert-a-to-null-in-a-string-column/76691/2?u=mlauber71

Meta Collection about KNIME and Java

https://hub.knime.com/-/spaces/-/~xLnTTC6zyiEveNq5/current-state/

Table Creator
regexReplace($column1$, "^ {6}$" ,toNull(""))
String Manipulation
if ( equals(column("column1"), " ")){toNull("")}else {column("column1")}
Column Expressions (legacy)
if(regex_match($["column1"], "^ {6}"), empty_to_missing(""), $["column1"])
Expression

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2024-01-21
On NodePit since: 2024-01-22
Last update: 2025-11-09
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!