- 论坛徽章:
- 24
|
本帖最后由 chengchow 于 2014-09-04 16:02 编辑
- awk 'BEGIN{x=4}NR==1{for(i=x;i<=NF;i++){a[i]=$i}{printf "%-10s %-10s %-10s %-10s\n",$1,$2,$3,"tel"}}NR!=1{for(i=x;i<=NF;i++){split($i,b,",");for(j in b){split(b[j],c,"-");for(k=c[1];k<=c[2];k++){l=length(c[1]);printf "%-10s %-10s %-10s %-0s",$1,$2,$3,a[i];printf "%0"l"d\n",k}}}}' 1
- province city citycode tel
- shanxi xi'an 29 1476300
- shanxi xi'an 29 1476301
- shanxi xi'an 29 1476302
- shanxi xi'an 29 1476303
- shanxi xi'an 29 1476020
- shanxi xi'an 29 1476021
- shanxi xi'an 29 14760010
- shanxi xi'an 29 14760011
- shanxi xi'an 29 14760012
- shanxi xi'an 29 17050660
- shanxi xi'an 29 17050661
- shanxi xi'an 29 17050662
复制代码 回复 6# jason680
恩,谢谢,咋又不说中文了
|
|