Trying to compare two columns that have strings concatenated by ' | ' and look like this:
COL A
abc | def | ghi
COL B
abc | xyz
Desired result:
COL C that contains the matching part of both strings.
In this case result should be: abc
COL D containing the count of matched parts of the string.
In this case, result should be: 1
Would appreciate your response.