- 论坛徽章:
- 18
|
本帖最后由 bikkuri 于 2021-02-14 10:33 编辑
awk -va=7 'NR==FNR{x[$1]=$2;next}{total+=$2;b[sprintf("%2s|%-20s|%5d",$1,x[$1],$2)]=NR}END{c=length(b);if(c%a==0){d=c/a}else{d=int(c/a)+1;e=sprintf("%2s|%-20s|%5s","","","")};for(f=0;f<=a;f++){g=g?g"--+--------------------+-----+":"+"};print g;PROCINFO["sorted_in"]="@val_num_desc";for(h in b){j=i++%d;k[j]=k[j]?k[j]"|"h:h};for(l=0;l<=d-1;l++){printf("|%s|\n",c%d==0||l<c%d?k[l]:k[l]"|"e)};print g; print "TOTAL: "total" employees as of "strftime("%Y-%m-%d %H:%M:%S")}' FS=":" country.txt FS=" " C1.txt
awk -va=8 '{if($1=="")$1="Unknown";total+=$NF;b[sprintf("%-20s|%5d",$1,$NF)]=NR}END{c=length(b);if(c%a==0){d=c/a}else{d=int(c/a)+1;e=sprintf("%-20s|%5s","","","")};for(f=0;f<=a;f++){g=g?g"--------------------+-----+":"+"};print g;PROCINFO["sorted_in"]="@val_num_desc";for(h in b){j=i++%d;k[j]=k[j]?k[j]"|"h:h};for(l=0;l<=d-1;l++){printf("|%s|\n",c%d==0||l<c%d?k[l]:k[l]"|"e)};print g; print "TOTAL: "total" employees as of "strftime("%Y-%m-%d %H:%M:%S")}' FS="\t" C2.txt
|
|