Comparing two Columns

[Anasalter]

Hello,

I have a dataset having two columns (Right Vendor name ) and Name.

I want to compare each value in first column with the adjacent value in second column 

for eg.

      right_vc  Name

1    abc         pqr

2    abcd       pqrstu
 

here row 1 value for left column should be compared with value of row 1 for (Name) column i.e abc should be compared to pqr
now if 90% of the string is matching i should get those results only.

[CoG]

how does the 90% logic work? are you comparing the first character to first character, and so on successively, or can characters be rearranged or broken up? Also, how much text are you working with? In your examples because you have less than 10 characters, perfect equality is the only check needed to satisfy a 90% match?

This is a complex procedure that needs further explanation. Please provide a representative sample input that highlights all success cases.

[cjaneczko]

You can use the Fuzzy Match tool to accomplish this. But can you provide actual sample data and the expected outcome. It doesnt look like any of the sample data is close to a match.