文件转换成csv时列内容包含逗号怎么处理

比如某列包含逗号，转换成csv时就会乱码，此时将该列两端添加双引号即可
https://blog.csdn.net/huangzx3/article/details/81475350

$ cat bac_network_info|cut -f7|grep ","|head 
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027
Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027

 为第7列添加双引号

awk -v FS='\t' -v OFS='\t' '{$7="\""$7"\"";print $0}' bac_network_info

#预览
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"
"Salmonella enterica subsp. houtenae serovar 16:z4,z32:-- str. RKS3027"

转换成csv格式：

sed "s/\t/,/g" bac_network_info > bac_network_info.csv

参考自awk打印时里面加引号或者其他符号_Bear.Huang的博客-CSDN博客_awk print 引号