PDA

View Full Version : Dup checking Mailing list.


ABC123

Troy Zoschke
06-12-2001, 01:54 PM
How do I dedup a mailing list.

First I am exporting my current database customers to a new database containing First Name, Last Name, Postal Code. I then get a mailing list that I append to the end of the first list. I want the dup check routine to mark both of the records as they already are a customer of ours and I don't want to mail them.

i.e. Mark Robert 54935
&
Mark Robers 54935

both marked! Not just the second one. I would then remove the customer records and have my complete mail list.

Also I assume I could match

Joseph Jones 54938
and
Joe Jones 54938

with a xbasic command in the duping process pulling the first 2 characters and the postal code?

Troy

Thomas Henkel
06-13-2001, 07:57 AM
Instead of deleting duplicates, why don't you just append unique only based on the customer number. that way you won't need to search for and delete duplicates.

Tom