Replace whole string if cell contains a certain string

Hello,

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

ABCDEFG              

HIJKL                    HIJKL

 

 

These rules:

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

should do what you want.

Cheers, gabor

1 Like

great!

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