Counting appearance of a string in a column

Hello professionals, I’m just new to Knime. Is there any way to like count for the appearance of a string in a column or many columns at the same time? Thank you a lot.

In a String manipulation node, you can try this bit:

count($yourString$, "substringToCount")

In a String Manipulation (Multi Column) this works for multiple columns:

count($$CURRENTCOLUMN$$, "substringToCount")

You might want to select to replace the input columns with this node (scroll down in the settings window).


Thanks, sir. It’s amazing.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.