Q:

Replace new lines character which are in quotas in file using sed

I have been exported file from open office to csv. But the long text in cell have new line characters. The rows with cell with text looks like this in csv
;;;;ddsfaads;;dsfaadsfdas;"
dfsafdas
fdadfsdaf
fddsfaadfs
fdsfadsadsfadf
"

how to do it?

A:

You can also use this way also ,
sed '/"/{:a;N;/\n.*"/{s/\n/ /g;p;d;t};s/\n/ /g; t a};' FileName

