Some words extract from string


I want to know about word extraction from string.
I have a string column and category column.

String column:
Accumulated depreciation
Advanced claim
Depreciation expenses
Advanced for traveling

Category column:
Depreciation => DP
Advanced => AD

I want to categorize in string column with “DP, AD” if related word included in string column.

Please Help,
Thank You


You will need to use

node with if…else java based expression. Node may need to be installed.


Hi izaychik63,

Thank you very much.

Hi there @Charm_Myae,

welcome to KNIME Community Forum!

If I got you right you can use Rule Engine node with following expressions using LIKE operator:

$column1$ LIKE “Depreciation” => “DP”
$column1$ LIKE “Advanced” => “AD”

Expressions are case sensitive so you might wanna add two more without capital letters at beginning.

Hope this helps!


1 Like

Hi ipazin,
Thank you very much :blush: :blush:

1 Like

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