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

I wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
J.S., Newark, OH