|
|
How to sort a content of a text file using a shell script?
12-10-2014
cpq-media cpq-telco DSS-IPAD06 DSS-IPAD07 GSE-DocuSign GSE-DocuSign1
$ awk '
$0 ~ /^.*[0-9][^-]*-/ { l=$0; sub(/[0-9].*/,"",$0); gsub(/^[^0-9]*|-.*/,"",l); A[$0]++; L[$0,l]++; next }
{ U[$0]++ }
END { for (i in A)
{ for (j in L) {split(j,a,SUBSEP); if (i == a[1]) T[i]++} printf "%-15s%8s\t%8s\n", i,T[i],A[i]}
for (k in U) n++; printf "%-15s%8s\t%8s\n", "unclassified","N/A",n
}' input_file | sort -nrk3,3 | awk 'BEGIN { printf "%-15s%s\t%s\n", "TYPE","ENV","COUNT"
printf "%-14s %s\t%s\n", "--------------","--------","--------" }
$1 != "unclassified" { e+=$2; c+=$3; print }
$1 == "unclassified" { l=$0; e+=$2; c+=$3; next }
END { print l; printf "%-14s %s\t%s\n", "--------------","--------","--------"; printf "%-15s%8s\t%8s\n", "",e,c }'
TYPE ENV COUNT
-------------- -------- --------
fap 1254 475732
psf 114 67601
unit 167 7415
jde 77 4383
NMDemo 35 3754
sbl 34 2890
ofm 1 592
NMTalent 6 592
/NMDemo 1 160
fapbs 1 160
bics 1 49
app 1 44
PRI 40 40
la 2 3
unclassified N/A 1660
-------------- -------- --------
1734 565075
$
12-10-2014
12-11-2014
unit18349_postclone-istoreb2c
gsub(/^[^0-9]+|-.*/,"",l)
)
|
|
|
|