Query or Regular Expressions to find similar names

[AHJ1]

A program that I am writing works from Extracts from several Excel Worksheets. I can import the data but because the Excel worksheets require manual input of the names of companies. Therefore, there are errors like this

A J MULLINS
AJ MULLINS
BARRICK GOLDSTRIKE MINE INC
BARRICK GOLDSTRIKE MINES INC
BLACK STONE MINERALS
BLACKSTONE MINERALS
CUNNINGHAM, PAUL
CUNNINGHAM, PAUL S
"DOUBLE ""D"" NEVADA LLC"
DOUBLE D NEVADA LLC
GREFCO INCORPORATED
GREFCO INCORPORTATED
H K VEAL & CO
H K VEIL & CO

Currently, I do a sort of entries by company name and examine them manually. Can anyone suggest a query or a function that uses regular expressions to automate the identification of these items? I have searched the forum, but did not find it on my own.

Thanks,
Alan

 

[randy700]

It may take some time to establish, but you could create a table that has two fields -- common "incorrect" spellings and the corrected spelling.

Somewhere during your import process, compare the incoming data to this table and make the necessary corrections.


Randy

 

[PHV]

You may consider a SOUNDEX function.

http://sqlpro.developpez.com/Soundex/SQL_AZ_soundex.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AHJ1]

Yes. Thank you. I am also considering an associative table. The problem is one of manual entry in the future. I know that people will continue to make typos and "human appropriate" name entries for Excel, which just won't work when we start to slice-and-dice in a database.

 

[AHJ1]

PHV,

Thanks for your suggestion. That may work well, but I can't tell, because my comprehension of French is limited.

http://arkham46.developpez.com/articles/office/clgdiplus/tuto/tutoclgdiplusexif/

Do you know if there is an English site?

 

[PHV]

Do a google search for soundex vba

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AHJ1]

Thanks.

 

[AHJ1]

For other people's reference:

http://smallwhitecube.com/php/dokuwiki/doku.php?id=code:vbasoundex