增加一列计算值。求助。

xswj77

源文件如下：
'5010000','200309',2,159
'5010000','200310',2,159
'5010000','200311',2199,3337
'5010100','200309',16841,40980
'5010100','200310',17187,41542
'5010100','200311',17507,42221
'5010100','200401',18281,43919
'5010100','200402',18670,43890
'5010500','200309',17806,41144
想增加第五列：计算方法为 ($3/$4)*100.
变成：
'5010000','200309',2,159, 1.257%
'5010000','200310',2,159 ,1.257%
'5010000','200311',2199,3337, 65.89%
'5010100','200309',16841,40980...
'5010100','200310',17187,41542...
'5010100','200311',17507,42221...
'5010100','200401',18281,43919...
'5010100','200402',18670,43890...
'5010500','200309',17806,41144...
怎么实现。多谢了。记得以前有类似的贴在，找不到了。

大红机器

1. awk -F, '{printf("%s, %.5s%\n",$0,($3/$4*100))}' file

复制代码

labrun

awk -F, '{print $0,","$3/$4*100"%"}' file

zhhui2000

awk -F,'{ print $0,$3/$4 }' aa.txt >bb.txt

xswj77

谢诸位