Support 805.461.7300
Sales
NEW SITE. 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 have been a loyal customer for 14 years and love your products. During my career as a mailing professional, I have experienced that the mailing industry is in a constant state of change: through technology, equipment, software, postal regulations and automation requirements. During this time, I have always been able to trust and depend on Accuzip software. It is evident Accuzip is always at the forefront of these changes. When our team is having difficulty with a mailing, we know that we can rely on Accuzip tech support to resolve any issue. We have always received excellent customer service. Accuzip software, support and expertise has helped me to develop a professional mailing operation at our University and I could not have done this without you. Your software makes my job successful and less stressful. Thank you!
D.H., Forest Grove, OR