Merge names that have the same address

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm

Merge names that have the same address

Post by Eric » Wed Sep 27, 2006 1:55 pm

If you have multiple records with the same address but different names in your database, this command and the small program that you can download will combine the names that share the same address into one record, and it will remove the duplicate addresses from the database.
Make sure you have the field "LAST" in the database and the names are parsed, the command bases the match on Address+last.

Download the file and unzip it into your C:\Program Files\AccuZIP6 5.0 folder.

Pull down the Edit menu to Command, and run this two-word Command:

Code: Select all

Do Family5.PRG
After running the command, the duplicates will be removed with one instance of each address kept, and the names that were in each duplicate will be added to the original record.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply