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

The [Merge Fields feature]...saved me hours of having to do a bunch of manual address corrections in an updated database, that I already had done months ago on my original database. What a relief. Certainly Rolaids can't top this.

V.J., Los Angeles, CA