Add SCF and Zone information to your database

Follow these instructions to make the command work:

Open AccuZIP6 5.0, any database, then select Commands… from the Edit menu.
Enter the code below in the command statement syntax area.
Change the 3-digit ZIP Code at the beginning of the command to the STARTING ZIP Code point from where the Zones will be calculated.
Click Run

* Get start 3-digit zipcode cZip3="980" cZip3=LEFT(cZip3,3) * Suppress Messages ON ERROR com_Mesg=MESSAGE() * Add SCF column; Add Zone column ALTER TABLE (ALIAS()) ADD COLUMN scf C(3) ALTER TABLE (ALIAS()) ADD COLUMN zone C(3) * Add SCF number REPLACE ALL scf WITH substr(GetLineValue(ADDBS(xDefFldr)+"iPresort\DMM\AZL002C.txt",INT(VAL(LEFT(zip,3))),67,.T.,.T.),9,3) * Get Zone Chart line ps5ZoneChartData=GetValue(addbs(xdeffldr)+"iPresort\DMM\azformat2.txt",cZip3,1,1,1,1,"","",1,1,1) ps5ZoneChartData=" "+substr(ps5ZoneChartData,4) * Add Zone number REPLACE all zone WITH SUBSTR(ps5ZoneChartData,val(left(zip,3))*2,1)

* Get start 3-digit zipcode
cZip3="980"
cZip3=LEFT(cZip3,3)

* Suppress Messages
ON ERROR com_Mesg=MESSAGE()

* Add SCF column; Add Zone column
ALTER TABLE (ALIAS()) ADD COLUMN scf C(3)
ALTER TABLE (ALIAS()) ADD COLUMN zone C(3)

* Add SCF number
REPLACE ALL scf WITH substr(GetLineValue(ADDBS(xDefFldr)+"iPresort\DMM\AZL002C.txt",INT(VAL(LEFT(zip,3))),67,.T.,.T.),9,3)

* Get Zone Chart line
ps5ZoneChartData=GetValue(addbs(xdeffldr)+"iPresort\DMM\azformat2.txt",cZip3,1,1,1,1,"","",1,1,1)
ps5ZoneChartData=" "+substr(ps5ZoneChartData,4)

* Add Zone number
REPLACE all zone WITH SUBSTR(ps5ZoneChartData,val(left(zip,3))*2,1)

When the command is completed, close the Command window.
Pull down the View menu to List View Default to see the newly-added fields, then scroll to the right in your database until you see the zone and SCF fields.

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

AccuZIP’s Professional Services Team has been a great resource for helping me launch Informed Delivery campaigns for my clients. I am a small direct mail marketing agency specializing in helping my clients find and retain new customers with direct mail. Informed Delivery is the best thing the post office has come up with in my 30+ years in the business. However, just like everything else with the post office, they don't make it easy. AccuZIP has made doing these digital campaigns very simple. I have analyzed campaign results and found the price per click through to the client's website less than an Adword campaign. I am looking forward to working with AccuZIP and their entire Professional Services Team with more clients and campaigns.

S.R., Raleigh, NC