Count number of substring matches between two strings

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

Hi!

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

Br,
Ivan

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”)

2 Likes

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