> I have to find duplicate customers in are customer file (around 60,000 > customers). > The file has been exported into a pipe delimited file. > > CustCode|Ship2Code|Name|Addr1|Addr2|City|State|ZipCode|Phone|F > ax|Country > The problem is the duplicates can be misspelled meaning you can't just > do an exact search. > My thinking was a couple of passes. Phone Numbers, Addresses, then > address digits & City.
So you are looking for duplicates on any field? Wouldn't you just be looking for a dup on the Name? Shouldn't the CustCode field be unique? Has your company thought about importing these files into a relational database. Would be much faster and easier. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
