Shell Programming and Scripting

BEGIN {
  FS=OFS="|"
}

{
  if ( int($NF) >= 600 ) next

  idx= $1 SUBSEP $2
  NF--; $1 = $1
  if (!(idx in arr))
     arr[ idx ] = $0
  cnt [idx]++
}
END {
  for ( i in arr )
    print arr[i], cnt[i]
}

BEGIN {
  FS=OFS="|"
  FLDinsert="3"
}

{
  idx= $1 SUBSEP $2
  NF--; $1 = $1
  if (!(idx in arr))
     arr[ idx ] = $0
  cnt [idx]++
}
END {
  for ( i in arr ) {
    n=split(arr[i], tmpA, OFS)
    tmpA[FLDinsert] = cnt[i] OFS tmpA[FLDinsert]
    for(iter=1; iter <= n; iter++)
        printf("%s%s", tmpA[iter], (iter < n) ? OFS : "\n")
  }
}