sed替换单引号

squall1

文件内容：
INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'缩地水电费\n水电费收到'),(3,'c'),(5,'d');

改为

INSERT INTO t1 (id, name) VALUES (1,e'\'沙发斯蒂芬'),(2,e'缩地水电费\n水电费收到'),(3,e'c'),(5,e'd');


就是字符串的value值，全部加一个e在引号前面，因为PG的转义符比较变态，默认和MySQL不一样。

谢谢。

jason680

回复 1# squall1

$ echo "INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'b'),(3,'c'),(5,'d');"
INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'b'),(3,'c'),(5,'d');

$ echo "INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'b'),(3,'c'),(5,'d');" | sed "s/\\\\'/''/g"
INSERT INTO t1 (id, name) VALUES (1,'''沙发斯蒂芬'),(2,'b'),(3,'c'),(5,'d');

龙牙地主天

1. awk 'gsub(",\047",",e\047")' <<< "INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'缩地水电费\n水电费收到'),(3,'c'),(5,'d');"

复制代码

squall1

谢谢大家谢谢大家谢谢大家

moperyblue

1. sed "s/,'/,e'/g"

复制代码

wh7211

回复 1# squall1

$ cat 1
INSERT INTO t1 (id, name) VALUES (1,'\'沙发斯蒂芬'),(2,'缩地水电费\n水电费收到'),(3,'c'),(5,'d');

$ sed -r 's/(.,)('"'"')/\1e\2/g' 1
INSERT INTO t1 (id, name) VALUES (1,e'\'沙发斯蒂芬'),(2,e'缩地水电费\n水电费收到'),(3,e'c'),(5,e'd');