Some words extract from string

KNIME Analytics Platform
#1

Hi,

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

Charm

#2

You will need to use


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

3 Likes
#3

Hi izaychik63,

Thank you very much.

#4

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!

Br,
Ivan

1 Like
#5

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

1 Like
#7

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