Support 805.461.7300
Sales
Our Technology. Your Success.

Mark Invalid ZIP Codes in a database

REPLACE x WITH "X" FOR EMPTY(SUBSTR(GetLineValue(ADDBS(xDefFldr)+"AZCTYSTATE.txt",VAL(LEFT(zip,5))+1,35),6,1))

When you export your data or when you show Marked records, look for a capital X in the x field. These will be your Invalid ZIP Code records.

« Back to Commands

You guys truly have the best support and customer service. I wasn't ready to switch software because of the fear of starting over, but you exceeded my expectations in the support and training. AccuZIP is the best & Eric you are so helpful and so knowledgeable. You have gone above and beyond to help me and it's appreciated more than you know. I will always be an AccuZIP customer
C.C., Tucson, AZ