I have a ,
separated string values in two different columns and need to match a specific value between these two columns.
Example:
Column A: A123,B234,I555,K987
Column B: AAA1,A123,B234,I555,K987
I want to check the value B234
from Column A
(which is starting 6th position) and B234
from Column B
(which is starting 11th position), if they are matching or not. I have few hundred of such records and need to check if these values are matching or not.