Determine if a cell contains certain characters

KNIME Analytics Platform
1

I need to determine which cells in a column contain “University of Oxford.” I need to append a column so that this table:

image

becomes:

image

Basically, I need a KNIME equivalent of the SEARCH function in Excel.

KNIME’s LIKE function via the Rule Engine node only produces “Yes” for cells that equal “University of Oxford”, not contain “University of Oxford”.

How do I fix this?

Many thanks!

2

LIKE in Rule Engine can be used with wildcards: ? and * matching one/more characters.

You can put * at beginning/end of the string.

6 Likes
3

Thank you! I tried wildcards via the IN function and didn’t get anywhere. XD

4

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