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

I do want to say that I deal with MANY software tech support departments, and yours is second to none, they never fail to resolve an issue and are always kind and courteous, that is sadly rare.

D.W., Fort Wayne, IN