Find the dups

[find the dups]

I'd like to find the dups in one of my table, there are all the company names
in the records, I know how to use the dups query, but my record have some
names like 'psc inc.' and 'psc,inc.' , how can I run the dups query exclude
the punctuation.

 

[Damian S]

Hi find the dups,

Try the replace function to remove punctuation, then check on those. Nest
them to remove multiple items... or write yourself a function to strip out
all whitespace and non alpha chars and compare on that.

Here's a sample of using the replace function:

replace(replace("bob, inc.", ",", ""), ".", "") will return "bob inc"

Try it!!

Damian.

 

[BigJohn]

You may want to look at the SoundEX function. The function is not clean, but
it does ignore punctuation and other "noise characters".