使用shell脚本替换csv文件中的数据

[observer@xxx-grey-openresty test]$ cat file.csv
beijing,beijing,lisi,10
shanxi,xian,tom,6
shanghai,shanghai,xiaoming,3
guangdong,guangzhou,wangwu,8
sichuan,chengdu,cat,5
[observer@xxx-grey-openresty test]$ awk -F, -v OFS=, '$4 > 5 {$4 = 3} {print}' file.csv
beijing,beijing,lisi,3
shanxi,xian,tom,3
shanghai,shanghai,xiaoming,3
guangdong,guangzhou,wangwu,3
sichuan,chengdu,cat,5
[observer@xxx-grey-openresty test]$

将输出结果保存到文件中

awk -F, -v OFS=, '$4 > 5 {$4 = 3} {print}' file.csv  > result.csv