Re: Find duplicated contacts (and typos)

2010-10-20 Thread Russ Michaels
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. 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

Re: Find duplicated contacts (and typos)

2010-10-20 Thread Mack
On Wed, Oct 20, 2010 at 4:22 PM, Russ Michaels r...@michaels.me.uk 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

RE: Find duplicated contacts (and typos)

2010-10-20 Thread Russ Michaels
Subject: Re: Find duplicated contacts (and typos) On Wed, Oct 20, 2010 at 4:22 PM, Russ Michaels r...@michaels.me.uk 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

Re: Find duplicated contacts (and typos)

2010-10-20 Thread Mack
On Wed, Oct 20, 2010 at 7:35 PM, Russ Michaels r...@michaels.me.uk wrote: 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, This is part of a larger app and the