处理数据库导入csv文件时，csv文件列中逗号对导入数据的影响

echo '"密码,西安",asss"ssdf,dfd","abc;def";sdfdsf,dfs'  | perl -pE 's/"([^"]*)"/ $a = $1; $a =~ s![^A-Za-z0-9_.]!!g; "\"$a\"" /eg' > 7.txt 
awk 'BEGIN{FS="\""; OFS=""}{for(i=2;i<=NF;i=i+2){$i=gensub(",","","g",$i)};print $0}' xxxxx_FDD.csv > result.csv

 

 

linux下汉子乱码

转码：
enca -L zh_CN -x UTF-8 work_param.csv