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

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