linux - awk 或 sed 更改文件中的列值

Question

我有一个csv文件，数据如下

16:47:07,3,r-4-VM,230000000.,0.466028518635,131072,0,0,0,60,0
16:47:11,3,r-4-VM,250000000.,0.50822578824,131072,0,0,0,0,0
16:47:14,3,r-4-VM,240000000.,0.488406067907,131072,0,0,32768,0,0
16:47:17,3,r-4-VM,230000000.,0.467893525702,131072,0,0,0,0,0

我想缩短第 5 列中的值。

期望的输出

16:47:07,3,r-4-VM,230000000.,0.46,131072,0,0,0,60,0
16:47:11,3,r-4-VM,250000000.,0.50,131072,0,0,0,0,0
16:47:14,3,r-4-VM,240000000.,0.48,131072,0,0,32768,0,0
16:47:17,3,r-4-VM,230000000.,0.46,131072,0,0,0,0,0

非常感谢您的帮助

Answer 1

awk '{$5=sprintf( "%.2g", $5)} 1' OFS=, FS=, input

这将四舍五入并在第一行打印 .47 而不是 .46，但这也许是可取的。