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
- Posts: 8
- Joined: Fri Sep 22, 2006 5:10 pm
- Location: Roanoke, VA
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
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"
- Posts: 8
- Joined: Fri Sep 22, 2006 4:01 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.