Count based on condition
Posted: Wed Dec 10, 2008 12:07 am
hi, i want to know how many records i have depending on a condition, and put the results on an output file , like a report, ex:
FB
record length= 50, the important field here is (31,2,CH)
output, FB, record length, 42
FB
record length= 50, the important field here is (31,2,CH)
----+----1----+----2----+----3----+----4----+----5
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX770001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX770001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX800001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX800001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX900001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX910001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX910001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX770001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX770001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX800001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX800001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX900001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX910001-01-01XXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXX-XX-XX910001-01-01XXXXXXXX
output, FB, record length, 42
----+----1----+----2----+----3----+----4--
77 80 90 91 92
CLIENTS 000002 000002 000001 000002 000000
77 80 90 91 92
CLIENTS 000002 000002 000001 000002 000000