替换拼接出现异常 ，求大神

mvplove123

有一个txt文件，内容是
"rizhao_5894";
"shanghai_city_17514";
"linfen_4028";
"heyuan_4577";
"jinzhong_3205";
"sanya_10514";
"wuhu_3082";
"fushun_2402";
"baoding_4349";
"puyang_2319";

现在 ，想在每一段的 前面加上sql语句 UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq=  
让每段都拼成
UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="rizhao_5894";
UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="linfen_4028";
......
我用sed替换，
[yongbo.tao@l-rdc1.h.cn6 ~]$ sed 's/^/UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq=/g' addChinese >addsql
-bash: CHINESE::hstore END WHERE hotel_seq=/g: No such file or directory

报这个错误

我用awk拼接

[yongbo.tao@l-rdc1.h.cn6 ~]$ awk  '{print "UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="$0}' addChinese >addSql
awk: {print "UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN language=
awk:        ^ unterminated string


求大神指教  ，感觉应该是空格 ，或者引号导致的

ly5066113

回复 1# mvplove123

1. sed 's/^/UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN \x27"language"=>"CHINESE"\x27::hstore ELSE attrs || \x27"language"=>"CHINESE"\x27::hstore END WHERE hotel_seq=/'

复制代码

OS_unix

sed -i "s#^#UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '\"language\"=>\"CHINESE\"'::hstore ELSE attrs || '\"language\"=>\"CHINESE\"'::hstore END WHERE hotel_seq=#g" text 这样试一下

jason680

回复 1# mvplove123

save the sql command in sql.cmd file
Note: easy to know what you want

$ cat sql.cmd
UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq=

$ awk 'BEGIN{"cat sql.cmd" | getline sql}{print sql$0}' FILE
UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="rizhao_5894";
...
UPDATE hotel_info SET attrs = CASE WHEN attrs IS NULL THEN '"language"=>"CHINESE"'::hstore ELSE attrs || '"language"=>"CHINESE"'::hstore END WHERE hotel_seq="puyang_2319";

Buring__

回复 5# jason680


    好 easy

fangang001

特殊字符处理的问题

mvplove123

这个可行 啊~回复 3# ly5066113


   

聆雨淋夜

回复 3# ly5066113
请教tim老师，sed是不是不支持八进制\047，支持十六进制\x27


   

ly5066113

回复 9# 聆雨淋夜


info sed


`\dXXX'
     Produces or matches a character whose decimal ASCII value is XXX.

`\oXXX'
     Produces or matches a character whose octal ASCII value is XXX.

`\xXX'
     Produces or matches a character whose hexadecimal ASCII value is XX.

聆雨淋夜

回复 10# ly5066113
多谢，祝新年快乐。