Erase Address2 when Apt number is in Address & Address2

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:

Erase Address2 when Apt number is in Address & Address2

Post by Eric » Fri Nov 09, 2007 8:41 am

If you find that some of the records in your database have apartment number information in the address field and that information is duplicated in the address2 field, the command below deletes the information out of address2 when there is a match:

Code: Select all

REPLACE address2 WITH "" FOR ALLT(UPPER(address2)) $ UPPER(address)
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply