Add NDC field and data to your database

If you want to add an NDC field to your database and populate it with the 3 digit NDC ZIP based on your 5-digit ZIP Code, then open your database, pull down the Edit menu to Command, and run this command:

* Suppress Messages ON ERROR com_Mesg=MESSAGE() * Add NDC column ALTER TABLE (ALIAS()) ADD COLUMN ndc(3) * Add NDC number REPLACE ALL ndc WITH substr(GetLineValue(ADDBS(xDefFldr)+"iPresort\DMM\AZL601.txt",INT(VAL(LEFT(zip,3))),67,.T.,.T.),9,3)

* Suppress Messages
ON ERROR com_Mesg=MESSAGE()

* Add NDC column
ALTER TABLE (ALIAS()) ADD COLUMN ndc(3)

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

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

This is the reason I feel so comfortable in recommending AccuZIP to other Allegra’s . Below is an email….subject line really… “Donna is AWESOME!” that I just received from a Philly center. Not just Donna but all customer facing AccuZIP employees are AWESOME!

T.P., Spartanburg, NC