5

I exported some data from a postgresql database using (all) the instruction(s) posted here: Save PL/pgSQL output from PostgreSQL to a CSV file

But some exported fields contains newlines (linebreaks), so I got a CSV file like:

header1;header2;header3
foobar;some value;other value
just another value;f*** value;value with
newline
nextvalue;nextvalue2;nextvalue3

How can I escape (or ignore) theese newline character(s)?

Community
  • 1
  • 1
t777
  • 3,099
  • 8
  • 35
  • 53

1 Answers1

5

Line breaks are supported in CSV if the fields that contain them are enclosed in double quotes.

So if you had this in the middle of the file:

just another value;f*** value;"value with
newline"

it will be taken as 1 line of data spread on 2 lines with 3 fields and just work.

On the other hand, without the double quotes, it's an invalid CSV file (when it advertises 3 fields).

Although there's no formal specification for the CSV format, you may look at RFC 4180 for the rules that generally apply.

Community
  • 1
  • 1
Daniel Vérité
  • 58,074
  • 15
  • 129
  • 156
  • 1
    Thank you. You are right. The problem was not the CSV-export but the import in Excel. Using libreoffice the file can be imported. – t777 Aug 29 '13 at 14:40