Support 805.461.7300
Our Technology. Your Success.

Fill Leading Zeros into the ZIP field

Use this command before you validate your database when you're importing an Excel file that has east coast or Puerto Rican addresses (ZIP Codes that have leading zeros). When you open the Excel file in AccuZIP6, the leading zeros that were part of the Excel formatting (but not part of the Excel data, which is key) won't appear in your file when you open the list in AccuZIP6, so the command below will fill the leading zeros back into the ZIP Codes in your database.

REPLACE zip with PADL(ALLT(zip),5,"0") FOR !EMPTY(zip) AND LEN(ALLT(ZIP))<5

« Back to Commands

You have the best support team of any company I have ever worked with!
S.R., Raleigh, NC