Search for a word within a string

KNIME Analytics Platform
1

Good afternoon everyone, how are you?

I need to search within a string for the words “SUPPORT” and “EXTRA” and filter.

For cases where there is Support, I would like a column written Support to be returned and for extras written extra.

It’s worth remembering that it doesn’t follow a standard.

Do you know how it can be done in the best way?

FMH-SJP-01_2024_SUPPORT_60675_0001
SUPPORT_SOC-SP3_2024_40293_0159(G)_136545
FMH-SJP-01EXTRA_2024_60675_0001
EXTRA_SOC-SP3_2024_40293_0159(G)_136545

2

Hi @Gabriel2020

Gor for the Rule Engine node.

$column1$ LIKE "*SUPPORT*"  => "SUPPORT"
$column1$ LIKE "*EXTRA*"  => "EXTRA"

gr. Hans

3 Likes