Support 805.461.7300
Our Technology. Your Success.

Convert the Barcode to ZIP4+DP Digits


This command will convert the AccuZIP6 barcode field digits and asterisks to a ZIP4+DP equivalent (see the example, below). This could be useful if you want to export the data to another program, then print the barcode information to a printer that only requires the ZIP+4 and Delivery Point numbers to produce the barcode. This command should only be run on a copy of the main database, like a print file or backup because AccuZIP6 requires the complete barcode when printing.

The Command At Work

Before Command After Command
Before running the command
After running the command

The Command

Copy this command, then paste it into the large text area of the command window:

Replace barcode with substr(strtran(barcode,"/",""),1,11) for "/" $ barcode

After clicking RUN, the barcode field will contain the zip+4 and the delivery point. You'll need to revalidate your database (Special --> Validate Records) to return the barcode field to its previous state.

« Back to Commands

"You should know and I have told this to many of the people I have spoken to on the phone over the years. All of your employees are always super helpful, knowledgeable and professional every time I need to call in. I always have my questions answered or my issue resolved. Thanks to you and your staff!"
A.B., Long Island City, NY