Compare similar fields

D

Dan

Hello All,

I'm trying to compare two tables (both with a field for
company name) to see how many companies are found in both
tables. However one table may have the company name with
punctuation or an abbreviation where the second table has
the same company name, just with different abbreviations,
punctuation etc. Is there a way to compare these two
tables and compensate for the possible differences in
company names?

Any suggestions would be helpful!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top