Counting appearance of a string in a column

[5lds]

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.

[Thyme]

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).

[5lds]

Thanks, sir. It’s amazing.