Looking for multiple expressions within strings

[hhaw]

Hi,

I’m trying to process sentences on the right, into the output strings, as seen in the attached image.
If a string doesn’t contain a word to look for, the original string is placed as an output.
The search also needs to be insensitive to case.

Note: There are many words to look for so each shouldn’t be it’s own node.

I thought perhaps a Rule Engine, or Rule Engine (Dictionary) but have not had any luck with either.

Thanks for any help.

[bruno29a]

Hi @hhaw , there are a few ways to do this. Here’s one way I did it. I added an additional sentence “Treehouse” to show that my workflow would not match it with Tree.

Here are the results:

I used SQL to do the match as I understand that you may have quite a list of words, and a JOIN probably works best, and since we’re not joining on exact whole match, but rather matching on particular word/phrase, I used a DB Join. In this case, I used a virtual H2 (it loads into memory, you don’t need to set up any H2 DB).

The workflow looks like this:

Here’s the workflow:
Looking for multiple expressions within strings.knwf (26.2 KB)

[hhaw]

Wow, this is a great solution, thanks!

[bruno29a]

No problem @hhaw , happy to help!