Convert the Barcode to ZIP4+DP Digits

Description

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.