需求:
对文本按逗号分割,并对指定列进行截取子字符串操作,并把打印替换结果
awk 'BEGIN{FS=OFS=","}{
for (i=1;i<NF;i++){
if(i==8){$8=substr($8,2,length($8)-2)}
if(i==9){$9=substr($9,2,length($9)-2)}
if(i==10){$10=substr($10,2,length($10)-2)}
if(i==12){$12=substr($12,2,length($12)-2)}
if(i==13){$13=substr($13,2,length($13)-2)}
if(i==14){$14=substr($14,2,length($14)-2)}
if(i==15){$15=substr($15,2,length($15)-2)}
if(i==16){$16=substr($16,2,length($16)-2)}
if(i==18){$18=substr($18,2,length($18)-2)}
}
}1' all_data_replace4.csv > all_data_replace5.csv
参考:
https://blog.csdn.net/weixin_39831705/article/details/113707396