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 just want to take a moment and let the folks at Accuzip know what great support I have received from Mathew Little. He has really helped get our IMB Barcode project off the ground! Learning Accuzip has been a pleasant process and the relief of knowing my project will be installed despite the tight deadline is wonderful! I wish there were more like you doing support at other companies when we need them.
M.V., Brentwood, TN