我尝试使用sed在csv文件中全局查找和替换,其中每个字段都由“和分隔,但字段的某些内容也可以包含”分隔。我正在尝试查找字段中最后一个字符是“并在其后插入一个空格,以便字段以空格而不是”结束的情况。
请注意,一行中可能有多个字段,其中字段的最后一个字符可以是“。
作为示例,下面是一些文件内容(4行)...
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven"","","",""
"303030","one two "three" "four"","five "six"","",""它应该变成..。
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven" ","","",""
"303030","one two "three" "four" ","five "six" ","",""即插入空格的3个位置:一次在第三行,两次在第四行。
目前,我已经得到了如下结果:
1,$ s/[^,]"",/" ",/g所以它会找到所有的匹配项,但不会保留匹配前的字符,所以我得到的结果是...
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seve" ","","",""
"303030","one two "three" "fou" ","five "si" ","",""如何使用sed获得所需的输出?或者使用awk?
谢谢。
发布于 2018-04-11 21:51:24
您需要创建一个捕获组,并在替换中使用反向引用:
sed -E 's/([^,"])""/\1" "/g' file
"123","def","","",""
"456","seven eight "nine" ten","","",""
"789"."twenty thirty sixty "seven" ","","",""
"303030","one two "three" "four" ","five "six" ","",""要以内联方式保存更改,请使用:
sed -i.bak -E 's/([^,"])""/\1" "/g' filehttps://stackoverflow.com/questions/49776698
复制相似问题