在csv文件中,我在下面的列中,尝试用更改第二列的值
awk -F ',' -v OFS=',' '$1 { $2=$2*2; print}' path/file.csv > output.csv
。
但是它返回零并删除双引号。
file.csv
"sku","0.47","supplierName"
"sku","3.14","supplierName"
"sku","3.56","supplierName"
"sku","4.20","supplierName"
output.csv
"sku",0,"supplierName"
"sku",0,"supplierName"
"sku",0,"supplierName"
"sku",0,"supplierName"
您可以在FS值中指定多个字符。
$ awk -v FS="\",\"" -v OFS="\",\"" '{$2=$2*2}1' file
"sku","0.94","supplierName"
"sku","6.28","supplierName"
"sku","7.12","supplierName"
"sku","8.4","supplierName"
如果要四舍五入到小数点后两位,请尝试此操作。
$ awk -v FS="\",\"" -v OFS="\",\"" '{$2=sprintf("%.2f",$2*2)}1' file
"sku","0.94","supplierName"
"sku","6.28","supplierName"
"sku","7.12","supplierName"
"sku","8.40","supplierName"
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句