shell sed 删除替换双引号之间的符号

229147123

shell sed 删除替换双引号之间的符号

例如：
asss"ssdf,dfd",sdfdsf,dfs
结果
asss"ssdfdfd",sdfdsf,dfs或者asss"ssdf||dfd",sdfdsf,dfs

sync_1521

sed -r 's/(".*),([^"]*")/\1\2/'
sed -r 's/(".*),([^"]*")/\1||\2/'

MMMIX

回复 1# 229147123


    需要二次替换呀, 这个 Perl 做起来倒是很方便:

$ echo 'asss"ssdf,dfd","abc;def";sdfdsf,dfs' | perl -pE 's/"([^"]*)"/ $a = $1; $a =~ s!\W!!g; "\"$a\"" /eg'
asss"ssdfdfd","abcdef";sdfdsf,dfs

tuyajie

一行如果有多个这个就挺麻烦了回复 2# sync_1521


   

songyc_2015

回复 1# 229147123

1. (tcp)~/priv/syc> cat file
   
2. asss,"aaa[bbb",sdfdsf,dfs
   
3. asss,"aaa,bbb;ccc",sdfdsf,dfs
   
4. asss,"aaa|bbb","aaa:bbb",sdfdsf,dfs
   
5. (tcp)~/priv/syc> sed -r ':1;s#"(\w+)\W([^",]+)"#"\1\2"#;t1' file
   
6. asss,"aaabbb",sdfdsf,dfs
   
7. asss,"aaabbbccc",sdfdsf,dfs
   
8. asss,"aaabbb","aaabbb",sdfdsf,dfs

复制代码

foreverys

大神，能解释下你sed里面的":","#","t"都是啥意思么
回复 5# songyc_2015


   

songyc_2015

回复 6# foreverys
大神，能解释下你sed里面的":","#","t"都是啥意思么

:表示定义标签，如:1表示定义标签1
s###与s///一样
t:表示前面的s替换成功，则跳转到标签1

ps:man sed/info sed

聆雨淋夜

sed -r 's/("[^"]+),([^"]+")/\1\2/g' file

rulebook

1. awk 'BEGIN{FS=OFS="\""} {for(i=2;i<=NF;i=i+2){$i=gensub(/,/,"","g",$i)};print $0}'

复制代码