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

becomes:

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!
qqilihq
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
mac95
3
Thank you! I tried wildcards via the IN function and didn’t get anywhere. XD
system
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.