原始文件 beforedelete.csv 内容如下
1st,2nd,3rd,4th,5th,6th
1st-a,2nd-a,3rd-a,4th-a,5th-a,6th-a
1st-b,2nd-b,3rd-b,4th-b,5th-b,6th-b
想要把 csv 中的第二列和第四列的内容删除,可使用如下命令
cat beforedelete.csv | awk -F, '{$2=null;$4=null;print $0}' | awk 'BEGIN{OFS=",";}{print $1,$2,$3,$4}' > afterdelete.csv
命令执行完毕生成的 afterdelete.csv 内容如下
1st,3rd,5th,6th
1st-a,3rd-a,5th-a,6th-a
1st-b,3rd-b,5th-b,6th-b
删除文件前三列
方法一:将第一列,第二列,第三列置空,重定向到一个新的文件中
awk '{$1="";$2="";$3="";print $0}' filename > newfilename
方法二:
awk '{for(i=4;i<NF;i++)printf("%s ",$i);print $NF}' filename >newfilename