remove the strings if those strings exists in another specific column

KNIME Analytics Platform
1

Hello,

I have the following example data.

image

The required output data is

image

the logic is,

if a certain string exists in the column2 and it also exists in column1 among some other strings, it removes that string from the column1.

I have attached the input and output data below.

Thanks,
Kanishka
Bookexampledata.xlsx (9.5 KB)

2

Hello @kanishka271
You can test the following code in a ‘String Manipulation’ node:

regexReplace( $column1$
             , join( "(?i)(.*?)", $column2$, "(.*$)" )
             , "$1$2" )

The operator (?i) makes it non case sensitive, you can remove it for your convenience.

BR

4 Likes