文本处理 - 数据折叠输出之二（国家、城市）

bikkuri

大家好！
我有一个问题向大家请教。
有以下这样三个文件：
C1.txt: 含有118个国家的缩写（2个大写字母），以及在该国家的人数，数字长度5个数字（取值区间1-99999）；
C2.txt: 含有342个城市的名称，以及在该城市的人数，数字长度4个数字（取值区间1-9999）；
country.txt: 含有所有国家缩写和全称的对应表；
txt.zip (4.74 KB, 下载次数: 6)

2021-01-31 21:05 上传

点击文件名下载附件

现在希望按照给定的列数，将以上排序表的内容按以下格式输出：
一、国家排名表
例如，当给定列数row=5时，根据总行数118，计算出需要5列24行才能打印出整个表格；
然后按照人数的多少，按第一列从上到下打印排名1-24的24个国家，每个国家依次打印国名缩写（2个字符长）、国名全名（20个字符长）、在该国的人数（5位数字长），其中国家名左对齐，人数右对齐；
然后第二列从上到下打印排名25-48的24个国家，第三列从上到下打印排名49-72的24个国家，依次类推，直到打印完最后一个国家，然后用空白补齐整个表格。


二、城市排名表
例如，当给定列数row=5时，根据总行数342，计算出需要5列69行才能打印出整个表格；
然后按照人数的多少，按第一列从上到下打印排名1-69的69个城市，每个城市依次打印城市名称（20个字符长）、在该城市的人数（4位数字长），其中城市名左对齐，人数右对齐；
然后第二列从上到下打印排名70-138的69个城市，第三列从上到下打印排名139-207的69个城市，依次类推，直到打印完最后一个城市，然后用空白补齐整个表格。
谢谢大家！

cfwyy

你不是已经做到了吗？   不然你的截图结果  是从哪里得来的？

bikkuri

1. awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

复制代码

bikkuri

1. awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

复制代码

bikkuri

awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

bikkuri

awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

bikkuri

回复 1# bikkuri

awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

bikkuri

什么情况？又发不了贴了！

bikkuri

回复 1# bikkuri

awk -va=5 'NR==FNR{x[$1]=$2;next}{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}' FS=":" country.txt FS=" " C1.txt

bikkuri

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