Replace whole string if cell contains a certain string


I'm new to KNIME and would like to remove/replace the whole content from each cell of a column that contains a certain string. The other cells from that column should keep their content though. I thought about using the Rule Engine node and it's probably quite simple but I cannot figure out how to do it. I'd be very grateful if you can help me with this issue!


Example: remove the content if old_column contains the string "ABC".

old_column     new_column

DEFG                     DEFG


HIJKL                    HIJKL



These rules:

$old_column$ LIKE "*ABC*" => ""
TRUE => $old_column$

should do what you want.

Cheers, gabor

1 Like


thanks a lot, that's exactly what I wanted!