Combine address fields when marked

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
KevinMIP
Private
Posts: 8
Joined: Fri Sep 22, 2006 5:10 pm
Location: Roanoke, VA
Contact:

Combine address fields when marked

Post by KevinMIP » Sat Sep 30, 2006 2:03 pm

Use this command when you have marked records where address2 begins with "Ste", "Apt" "#", "Number", "SE", "SW", "NE", "NW", "PMB", "Trailer", "Lot", "Unit", etc. This allows for a complete address field. We have created a saved search that marks the appropriate records.

The command combines the following information into the address field: Address and address2 separated by a space and then it deletes all information in address2 for only the marked records.

Code: Select all

replace all address with allt(address)+" "+allt(address2), address2 with "" for alltrim(X)="X"

Steve
Private
Posts: 8
Joined: Fri Sep 22, 2006 4:01 pm

Post by Steve » Mon Oct 30, 2006 10:46 pm

You can also Validate the Records and AccuZIP6 will automatically join Address and Address2 when applicable. If the match is to a high-rise building, AccuZIP6 looks in the field to the right, hence the Address2 field for the high-rise information. The software attempts to Validate the record again and if the information in Address2 is a match, Address and Address2 are joined together and then Address2 is blanked out.

Also, if you have the Ste/Apt information inside the main Address field and the regular Address in Address2, AccuZIP6 will automatically flip-flop the information and place it inside Address.

Post Reply