CSV File Format

Commands that set or modify the file format for input or output CSV files

Choosing the correct file format when reading or writing CSV files is essential for interpreting or writing them.
The commands in this chapter allow reading and writing CSV tables in uncommon formats, or converting them according to the needs of other, subsequently called applications.

±colnames, ±c
Defining whether the csv file has a header line containing the column names
±delimiter, ±d
Delimiter setting of the input or output CSV file
±linebreak, ±l
Defining which line break standard will be used (Windows, Linux or MacOS)
±quotechar, ±q
Defining which text quotation character is used in the CSV file
-forcequote, -f
Defining whether CSV data fields will have to be enclosed in quotation characters
±escapechar
Defining how to mark quotation characters inside a quoted field
±usenull, ±u
Defines whether "null" is supported for file input or output
±comments
Defining which CSV lines or rows are interpreted as comment lines
+skiprows
Defining which CSV line numbers or row contents shall be skipped