IBM Mainframe Forum

[Rockorebel]

Im having a file lenght 600 bytes(whereas first 3 bytes is number...40 to 56 is name field) ...I want a output file with heading and count

Input
123 abc
123 abc
123 abc
234 edf
234 edf
345 brc
345 brc

Required output
Num name count
123 abc 3
234 edf 2
345 brc 2

[NicC]

What have you tried? Have you looked at the manual? the DFsort Tricks manual? I am pretty sure that ther is something in one of these that does what you want. Unfortunately all my snippets have disappeared.