Chapter 3: Invoking pspp
3.5 OpenDocument Output Options
To produce output as an OpenDocument text (ODT) document, specify -o file on the
pspp command line. If ﬁle does not end in .odt, you must also specify -O format=odt.
ODT support is only available if your installation of pspp was compiled with the libxml2
The OpenDocument output format does not have any conﬁgurable options.
3.6 Comma-Separated Value Output Options
To produce output in comma-separated value (CSV) format, specify -o file on the pspp
command line, optionally followed by any of the options shown in the table below to cus-
tomize the output format.
Specify the output format. This is only necessary if the ﬁle name given on -o
does not end in .csv.
Sets the character used to separate ﬁelds. Default: a comma (‘,’).
Sets qualiﬁer as the character used to quote ﬁelds that contain white space,
the separator (or any of the characters in the separator, if it contains more
than one character), or the quote character itself. If qualiﬁer is longer than one
character, only the ﬁrst character is used; if qualiﬁer is the empty string, then
ﬁelds are never quoted.
Whether table titles (brief descriptions) should be printed. Default: on.
Whether table captions (more extensive descriptions) should be printed. De-
The CSV format used is an extension to that speciﬁed in RFC 4180:
Each table row is output on a separate line, and each column is output as a
ﬁeld. The contents of a cell that spans multiple rows or columns is output only
for the top-left row and column; the rest are output as empty ﬁelds.
When a table has a title and titles are enabled, the title is output just above
the table as a single ﬁeld preﬁxed by ‘Table:’.
When a table has a caption and captions are enabled, the caption is output
just below the table as a single ﬁeld preﬁxed by ‘Caption:’.
Footnotes Within a table, footnote markers are output as bracketed letters following the
cell’s contents, e.g. ‘[a]’, ‘[b]’, .. . The footnotes themselves are output fol-
lowing the body of the table, as a separate two-column table introduced with a
line that says ‘Footnotes:’. Each row in the table represent one footnote: the
ﬁrst column is the marker, the second column is the text.