Count marked records and fill count into another field

This command can take the total number of times a given value is in a field, and put the count into another field. In the example below, if you have 50 marked records, it'll put the number 50 into field1 for every marked record.

PUBLIC com_Count SET TALK OFF COUNT FOR !EMPTY(x) TO com_Count REPLACE field1 WITH ALLT(STR(com_Count)) FOR !EMPTY(x)

PUBLIC com_Count
SET TALK OFF
COUNT FOR !EMPTY(x) TO com_Count
REPLACE field1 WITH ALLT(STR(com_Count)) FOR !EMPTY(x)

For the sake of looking at a specific value in a field, you could change the last two lines of the command to:

COUNT FOR "X" $ x TO com_Count REPLACE field1 WITH ALLT(STR(com_Count)) FOR "X" $ x

COUNT FOR "X" $ x TO com_Count
REPLACE field1 WITH ALLT(STR(com_Count)) FOR "X" $ x

If field1 is a Numeric type field, change the last line of the command to read:

REPLACE field1 WITH com_Count FOR !EMPTY(x)

REPLACE field1 WITH com_Count FOR !EMPTY(x)

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

As a new customer of Accuzip, I just wanted to thank you for all of Accuzip’s help and patience with us in preparing this job so well. Our particular thanks to your technicians for multiple support calls and emails with our elementary questions while we learned on-the-job. Frankly, none of us had any experience with postal regulations or mail list technology, so we are especially grateful to have had them as a resource. Please tell them how much we appreciate their help!

K.M., Atlanta, GA