一个csv文件处理的问题

crasshopper

有一个csv 的文件，用逗号隔开，其中第二行里面有一个回车
"id0","name0",99999,"aaaaaaaa0","ccccc0"
"id","name",99999,"aaaa
aaaa","ccccc"
"id1","name1",99999,"aaaaaaaa1","ccccc1"


想要得到的csv文件是

"id0","name0",99999,"aaaaaaaa0","ccccc0"
"id","name",99999,"aaaaaaaa","ccccc"
"id1","name1",99999,"aaaaaaaa1","ccccc1"

求助

yinyuemi

回复 1# crasshopper


    sed -zr 's/("[^\n"]+)\n([^"\n]+")/\1\2/g'

ljwd1000

1. awk '{ORS=/[^\"]$/?"":"\n"}1'

复制代码

来个awk的

crasshopper

回复 3# ljwd1000



"id0","name0",99999,"aaaaaaaa0","ccccc0"
"id","name",99999,"aaaa
aaaa","ccccc"
"id1","name1",99999,"aaaaaaaa1","ccccc1"
ObjectID(5669999),"电话",,"asfdasfdafd
88623 asdfasdf",1232132
"id0","name0",99999,"aaaaaaaa0","ccccc0"




换一个真实的数据吧。。。

好像处理有点问题

   

crasshopper

回复 2# yinyuemi


加上-z 报错，是我这里版本的问题吗


   

LikeLx

1. sed ':a;N;/\n\"/!s/\n//;ta;P;D'

复制代码

jcdiy0601

1. sed '/"$/!N;s/\n//' file

复制代码

runintostar

回复 1# crasshopper

1. sed ':1;/\(,\"[^"]*$\)\|\(^\"[^"]*$\)/N;s/\n//g;t1'

复制代码

bb659030105

sed '/[^"]$/{N;s/\n//}'