首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >sed/awk -在模式匹配后插入空格

问sed/awk -在模式匹配后插入空格
EN

Stack Overflow用户
提问于 2018-04-11 21:40:23
回答 1查看 590关注 0票数 1

我尝试使用sed在csv文件中全局查找和替换,其中每个字段都由“和分隔,但字段的某些内容也可以包含”分隔。我正在尝试查找字段中最后一个字符是“并在其后插入一个空格,以便字段以空格而不是”结束的情况。

请注意,一行中可能有多个字段,其中字段的最后一个字符可以是“。

作为示例,下面是一些文件内容(4行)...

代码语言:javascript
复制
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven"","","",""
"303030","one two "three" "four"","five "six"","",""

它应该变成..。

代码语言:javascript
复制
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven" ","","",""
"303030","one two "three" "four" ","five "six" ","",""

即插入空格的3个位置:一次在第三行,两次在第四行。

目前,我已经得到了如下结果:

代码语言:javascript
复制
1,$ s/[^,]"",/" ",/g

所以它会找到所有的匹配项,但不会保留匹配前的字符,所以我得到的结果是...

代码语言:javascript
复制
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seve" ","","",""
"303030","one two "three" "fou" ","five "si" ","",""

如何使用sed获得所需的输出?或者使用awk?

谢谢。

EN

回答 1

Stack Overflow用户

发布于 2018-04-11 21:51:24

您需要创建一个捕获组,并在替换中使用反向引用:

代码语言:javascript
复制
sed -E 's/([^,"])""/\1" "/g' file

​

代码语言:javascript
复制
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven" ","","",""
"303030","one two "three" "four" ","five "six" ","",""

要以内联方式保存更改,请使用:

代码语言:javascript
复制
sed -i.bak -E 's/([^,"])""/\1" "/g' file
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/49776698

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档