Check if random word is contained in String

[denajaha]

Hello everyone,
I am retreiving very big Strings from the API, there is around 2000 words per String. I have to check if word “xxx” is contained in that String. If yes, I have to change the value of another column.
Any ideas how to solve this?

Kind regards,
Denis

[izaychik63]

Use Rule Engine with LIKE
$String$ LIKE “word”