Support 805.461.7300
Sales
Our Technology. Your Success.

Merge Data from Duplicate Records into 1 record and 1 Field

This command will combine information from up to 3 different fields and 30 duplicate records into one record.
  • Download the command file to your system.
  • Extract the “Merge Dup Information Into A Single Field 30 Max.txt” into the AccuZIP6 5.0\Commands Folder.
  • Extract the “merge_dup_any30.FXP” directly into the AccuZIP6 5.0 folder.
  • Open the database that you would like to run the command on.
  • Run the duplicate search as normal, MAKE SURE TO SELECT “Backup Duplicates” in that screen.
  • Run the command from the Edit|Command option. This command will combine up to 30 matching records into one field.
  • In the command you can combine up to 3 fields, simply list the fields in the command.
Example:
**1st Field**
COM_FIELD="FIRST"
=MERGE_DUP_ANY30()
**1st Field**

« Back to Commands

As a new customer of Accuzip, I just wanted to thank you for all of Accuzip’s help and patience with us in preparing this job so well. Our particular thanks to your technicians for multiple support calls and emails with our elementary questions while we learned on-the-job. Frankly, none of us had any experience with postal regulations or mail list technology, so we are especially grateful to have had them as a resource. Please tell them how much we appreciate their help!
K.M., Atlanta, GA