Crikey, you must just have a really shagged contacts list LOL. Have you tried Plaxo, this does a very good job of removing duplicates. Or does it need to be an in-house app ?
Russ -----Original Message----- From: Mack [mailto:[email protected]] Sent: 20 October 2010 14:43 To: cf-talk Subject: Re: Find duplicated contacts (and typos) On Wed, Oct 20, 2010 at 4:22 PM, Russ Michaels <[email protected]> wrote: > > Sadly I don;t think soundex is going to help you as this finds words > that sound like other words (there, their, they're), which isn't going > to pickup typos. In my testing soundex works reasonable well if I allow the 2 values to be within a distance of each other (I'm not searching for exact soundex matching but for the 2 numbers to be close to each other). For example "select soundex('Morris'), soundex('Moris');" returns the same value M620 and that is ok for me. > I think comparing each contact field on an OR basis is a sufficient > way to find dupes, if none of those fields are the same then it is not > really a duplicate. Even if you have a typo in the same, the other > fields are going to have a match surely. Unfortunately I get very little duplicates that way because of small differences, especially in the address ("East Drive" vs "East Dr."). -- Mack ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
