Validating addresses into a standard format for deduplication is a field in its own right. If you want to do this in a meaningful manner than you'll need to validate the addresses prior to database load using a product such as Global Address and then to do the comparison which an application that uses something like SSA's Name3 matching Technology.
Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -----Original Message----- From: Andrew Kuebler [mailto:[EMAIL PROTECTED] Sent: 21 July 2004 15:04 To: [EMAIL PROTECTED] Subject: Mailing Address Deduplication 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 on the right track or is there a trick someone I haven't found? Thank you. Best Regards, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
