Page 1 of 1

Add records and split names based on first

Posted: Thu Mar 19, 2009 7:06 am
by Dave
This command will duplicate a record and split the name information into the added records, when you have multiple names separated by a comma in the field named "FIRST"

Example:

Input:

First Address
John Smith, Cathy Smith, Joe Smith, Jerry Jones, Sam Reed, Jennifer Howard 100 Main ST

Output:

First Address
John Smith 100 Main ST
Cathy Smith 100 Main ST
Joe Smith 100 Main ST
Jerry Jones 100 Main ST
Sam Reed 100 Main ST
Jennifer Howard 100 Main ST

INSTRUCTIONS
1. Download and extract the addrecord.zip file to the C:\Program Files\AccuZIP6 5.0 folder.
2. Move the “Add Record Based On Names In First.txt” to the C:\Program Files\AccuZIP6 5.0\Commands folder. (Leave the other 2 .FXP files in the root level of AccuZIP6 5.0)
3. Open the database containing the names with commas in the field named FIRST.
4. Pull down Edit>Commands in AccuZIP6.
5. Click RUN.
6. The command will add additional records with the same address and split the names into those addresses up to 10 names.