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

We have over 200 vendors we work with on a daily basis and (the AccuZIP6 techs) are the most knowledgable, helpful group of folks I have worked with, always willing to go out of the way to help. As owner and GM of a Print and Mail Shop I admire the dedication these folks have in making sure we are satisfied. I also appreciate the fact that a human answers the phone.

M.S., Mt. Vernon, IL