两个文件求和

nxlinux

1. 
   
2. 
   
3. awk -F"\t" -v i=0 -v OFS="\t" 'NR==FNR{if($1){t=$1;ti[i]=$1;i++}{a[t","$2]=$3;b[t","$2]=$3;}}NR>FNR{if($1){t=$1}{a[t","$2]+=$3;c[t","$2]=$3;}}END{for(l=0;l<=i;l++){n=1;for(j in a){split(j,ss,",");st=ss[1];sf=ss[2];stt=ti[l];a1=a[stt","sf];b1=b[stt","sf];c1=c[stt","sf];if(!b1){b1=0};if(!c1){c1=0};if(st==stt){if(n==1){print stt,sf,b1,c1,a1;n=2}else{print "",sf,b1,c1,a1}}}}}' a b
   
4. 
   

复制代码