[AccessD] Any good name matching algorithms in VBA

 Thanks. . .


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Friday, December 02, 2011 1:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Any good name matching algorithms in VBA


Ed - I once had a project to convert mis-spelled names and typical
aliases to a "standard name". This client had inconsistent data coming
from multiple sources. It had to be consolidated. It was pretty simple
actually. I built a cross-reference table that associated all alias's
and mis-spellings to a single reference name. Every month we'd run the
matching process I developed, find more "drop outs" (reference names
with no matches), And then just add them to the cross-reference table
and re-run the reports. I did this in Excel, but definitely doable in
Access with a single table.

That's a table-driven approach.
Now if you want something more elegant and heuristic,
ask those two guys who started this small company with a funny name that
begins with a G. They're pretty good at matching-up words.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd- 
> bounces at databaseadvisors.com] On Behalf Of Edward Zuris
> Sent: Friday, December 02, 2011 1:47 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Any good name matching algorithms in VBA
>
>
>  Does anyone know where I can find some good name
>  matching algorithms in VBA, and or examples, that
>  I can look into ?
>
>  Thanks.
>
>  Ed Zuris.
>  edzedz at comcast.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com