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 been using the AccuZIP software for over seven years now. I believe that being an AccuZIP customer is one of the reasons for our success. Every time a question has arose, AccuZIP answered it completely and competently. When the post office did not have an answer for us AccuZIP did. If there was ever any conflicting info between the Post Office and AccuZIP, our AccuZIP customer service rep was always correct. We have experienced only excellent customer service. Let me make that clear not good customer service, excellent customer service.

C.M., Show Low, AZ