替換拼接出現(xiàn)異常 ，求大神

mvplove123

有一個(gè)txt文件，內(nèi)容是
"rizhao_5894";
"shanghai_city_17514";
"linfen_4028";
"heyuan_4577";
"jinzhong_3205";
"sanya_10514";
"wuhu_3082";
"fushun_2402";
"baoding_4349";
"puyang_2319";

現(xiàn)在 ，想在每一段的 前面加上sql語(yǔ)句 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

報(bào)這個(gè)錯(cuò)誤

我用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


求大神指教  ，感覺應(yīng)該是空格 ，或者引號(hào)導(dǎo)致的

ly5066113

回復(fù) 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=/'

復(fù)制代碼

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

回復(fù) 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__

回復(fù) 5# jason680


    好 easy

fangang001

特殊字符處理的問題

mvplove123

這個(gè)可行 啊~回復(fù) 3# ly5066113


   

聆雨淋夜

回復(fù) 3# ly5066113
請(qǐng)教tim老師，sed是不是不支持八進(jìn)制\047，支持十六進(jìn)制\x27


   

ly5066113

回復(fù) 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.

聆雨淋夜

回復(fù) 10# ly5066113
多謝，祝新年快樂。