On Wednesday 21 July 2004 15:04, Andrew Kuebler might have typed: > I know this is not necessarily a MySQL question, but everyone on this > listserv is always so helpful and I was wondering if anyone had any > pointers on how to deduplicate a list of mailing address since there can > be so many inconsistencies on how an address can be written (road vs rd vs > rd., etc). I was thinking that I probably needed to find a way to > standardize the addresses using USPS standards and then deduplicate. Am I
perl String::Compare may be what you need. Colleague of mine has been using it to determine if UK addresses are the same by weighting the postcode heavily, and then letting the comparison of the address determine dupes. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
