如何给csv文本中含有单引号'的内容加上转义符\

bikkuri

大家好！
我有一个问题向大家请教！
有这样一个文本，其中有一个字段的值中含有一个单引号'，导致mysql不能正常执行。
INSERT INTO Employee(RealName,DisplayName,ChineseName,CSLogin,BusinessTitle,Department,Company,Location,Country,City,Email,Mobile,UPI,NokiaID,NID,NokiaAccount,BossNID) VALUES('BILBEE Sashi ','Bilbee, Sashi (Nokia - US/Naperville)','','palanisw','Head of Americas Repair Stgy & ION Eng'g','MN Services','Nokia of America Corp.','US/Naperville','US','Naperville','sashi.bilbee@nokia.com','+16303999260','PA0001546','69045105','120632','nsn-intra\palanisw','125333');
请问应该如何用sed命令在这个单引号'前加上转义符\呢？
谢谢！

bikkuri

回复 1# bikkuri

sed "s/\(\w\)\('\w\)/\1\\\\\2/g" file
INSERT INTO Employee(RealName,DisplayName,ChineseName,CSLogin,BusinessTitle,Department,Company,Location,Country,City,Email,Mobile,UPI,NokiaID,NID,NokiaAccount,BossNID) VALUES('BILBEE Sashi ','Bilbee, Sashi (Nokia - US/Naperville)','','palanisw','Head of Americas Repair Stgy & ION Eng\'g','MN Services','Nokia of America Corp.','US/Naperville','US','Naperville','sashi.bilbee@nokia.com','+16303999260','PA0001546','69045105','120632','nsn-intra\palanisw','125333');

转义符跟不要钱的似的，大把地给啊