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

You guys have indeed been great partners in aiding us with getting our mailings processed through your software and out the door. I want to say we’ve been with you guys for at least 12 years now, if not longer. Find something good you stick with it is how I see it.

P.H., Colorado Springs, CO