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 appreciate [AccuZIP support technician] Geoff! He has over and over with a positive attitude given us exceptional support. He is a key asset to us and we are so thankful for him. I just wanted to let you all know that he has so much patience and knowledge. I am sure you know but he is a KEEPER for your company.
K.P., Colorado Springs, CO