- 论坛徽章:
- 32
|
- [root@localhost ~]# cat i
- a1 b1 c1 1 0.0
- a1 b1 c2 2 826.0
- a1 b1 c3 3 170.0
- a1 b1 c4 4 375.0
- a2 b1 c1 5 0.0
- a2 b1 c3 6 5.0
- a2 b1 c4 7 826.0
- a2 b1 c5 8 170.0
- a3 b1 c1 9 0.0
- a3 b1 c2 10 375.0
- a3 b1 c3 11 826.0
- a3 b1 c4 12 170.0
- a3 b1 c5 13 0.0
- [root@localhost ~]# awk '{t=$1"\t"$2;sub(/c/,"",$3);a[t,$3]=$4;b[t,$3]=$5;c[t]}END{for(i in c){printf i;for(j=1;j<=5;j++){if(a[i,j]=="")a[i,j]=0;printf "\t"a[i,j]}for(j=2;j<=4;j++){if(b[i,j]=="")b[i,j]=0;printf "\t"b[i,j]}print ""}}' i | sort
- a1 b1 1 2 3 4 0 826.0 170.0 375.0
- a2 b1 5 0 6 7 8 0 5.0 826.0
- a3 b1 9 10 11 12 13 375.0 826.0 170.0
- [root@localhost ~]#
复制代码 |
|