Combine multiple people at the same address into 1 record

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
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Combine multiple people at the same address into 1 record

Post by Eric » Thu Jun 09, 2011 8:08 am

The following command will combine multiple people at the same address into one record. Instead of merging two or more people with the same name as “The Jones Family”, they will be listed by first name and separated with “and”, e.g., John and Mary Jones, and Bob Thomas vs. The Jones Family, and Bob Thomas.

Download the familyfriendsnamemergeand.zip file, then extract it into the C:\Program Files\AccuZIP6 5.0 folder.

With your database open in AccuZIP6, pull down the Edit menu to Command. Copy the command from the Code box below and paste it into the Command Statement Syntax area of the Command window:

Code: Select all

*To format First as Uppercase, enter 1 as the parameter

=FamilyFriendsNameMergeAnd(1)

*To format using PerfectCaps, leave parameter out or use 0

=FamilyFriendsNameMergeAnd()

This automatically creates a new database in the same folder as the original with “_new.dbf” as the ending, e.g., Demofile.dbf would result in Demofile_new.dbf.

The following field names must be present in the database:

First
Last
Address
Zip
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply