Hi Guys,

I want to write a perl/shell script do parse the following file

input file content
NPA-NXX SC
2084549 45
2084552 45
2084563 2007
2084572 45
2084580 45
3278411 45
3278430 45
3278493 530
3278507 530
3278508 44
3278514 44



the output i require should contain first columns first three digits and then the count of numbers with that first three digits per SC wise

NPA Count(NPA) SC
208 6 45
208 1 2007
327 2 530
327 2 44


Thanks and regards

sed 's/.... / /' file | sort | uniq -c

thanks

With AWK, only if you are curious

(use nawk or /usr/xpg4/bin/awk on Solaris):

awk 'END {
  for (k in _) {
    split(k, t, SUBSEP)
    print t[1], _[k], t[2]
    }
  }
NR == 1 { print; next }
{ _[substr($1,1,3), $2]++ }
' filename