Shell Programming and Scripting

|site1|MAP
|site2|MAP
|site1|MODAL
|site2|MAP
|site2|MODAL
|site2|LINK
|site1|LINK

SiteName MAP MODAL LINK
--------------------------
site1     | 1     |  1  |  1
site2     | 2     |  1  |  1

countmap=`grep $SITEID $FILENAME | grep MAP | wc -l`
countmodal=`grep $SITEID $FILENAME | grep MODAL | wc -l`
countlink=`grep $SITEID $FILENAME | grep LINK | wc -l`
echo $SITEID\|$countmap\|$countmodal\|$countlink\|

awk -F\| '{sites[$2]; c[$2,$3]++ }
END {
   OFS=" | "
   print "SiteName MAP MODAL LINK"
   print "-----------------------"
   for(site in sites) print site, 0+c[site,"MAP"],0+c[site,"MODAL"], 0+c[site,"LINK"]
}' infile

[ok@x60 ~]$ cat xxx | awk '{a[$1]++} END{for (x in a) {print x "\t" a[x]}}'

awk -F"|" '{c[$2,$3]++;b[$2]=$2 FS 0+c[i,"MAP"] FS 0+c[i,"MODAL"] FS 0+c[i,"LINK"] FS} END {for ( i in b) { print b[i]}}' filename;

awk -F"|" '{c[$2,$3]++;b[$2]=$2 FS 0+c[$2,"MAP"] FS 0+c[$2,"MODAL"] FS 0+c[$2,"LINK"] FS} END {for ( i in b) { print b[i]}}' filename