Count number of substring matches between two strings

[alfroc]

Hi,
would anybody suggest me a way to get the column COUNT from the following data?
Thanks!
Alfredo

column1 column2 => COUNT
“A B C” “A C” => 2
“A B” “A C D” => 1
“B D” “D B” => 2
“C D” “A B” => 0
“A” “A0 A AZ” => 1

[ipazin]

Hi!

You can use String Manipulation or Column Expressions node with function countChars()

Br,
Ivan

[alfroc]

Solution found.

Cell Splitter (on column1) + Column expressions

count(column(“column2”), column(“column1_Arr[0]”),“w”)+
count(column(“column2”), column(“column1_Arr[1]”),“w”)+
count(column(“column2”), column(“column1_Arr[2]”),“w”)