Delete row content

KNIME Analytics Platform
1

Hi,

maybe I think to complicated: I have several rows filled with different content (strings). I now would like to delete all of the row content in certain rows, where there are strings that contain “Missing”. Before and after “missing” is a variety of other strings: e.g. blah hx - MISSING (iu) etc.

What I now would like to achieve is that rows with this search phrase are just emptied (from their content), NOT deleted in general, because I need other columns with this row later on. So no RowFilter etc.

Silly question?

grafik
grafik1047×193 11.9 KB

should be:

grafik
grafik1047×193 7.15 KB

Thanks in advance for any hint.

2

string manipulation multi-column with an inline if clause should yield the best performance.

1 Like
3

Its always best to provide actual data rather than a screenshot. Makes it easier for helpers to construct a workflow.
Try this:

String Man
String Man1113×721 206 KB

Outtput
Outtput1322×321 54.8 KB

You can replace the original columns if you want. I used new columns so you could see the changes.

5 Likes
4

Perfect, thank you @rfeigel
I’ve never would have came up with this solution. :folded_hands:

5

Glad I could help. Regex is a pain but powerful.

1 Like