-
-
Notifications
You must be signed in to change notification settings - Fork 10
CSV Format
CSV is a comma* separated value format, going like
a1,b1,c1
a2,b2,c2
which can be read as a table like
________________
| a1 | b1 | c1 |
________________
| a2 | b2 | c2 |
________________
* the delimiter is changeable, see the following presets
The following site documents
The record separator has to be one of \r \n \r\n for imports.
Other separators aren't supported.
Custom formats currently use \r\n as record separators.
Presets are taken from the CSV lib
The following is a list of available presets.
Settings not mentioned are false / not set.
\n is a newline \r is carriage return
(\r\n is a specific representation of a newline)
Standard comma separated format, as for RFC4180 but allowing empty lines.
- Delimiter:
, - Quote:
" - Record Separator:
\r\n - Ignore Empty Lines: true
Excel file format (using a comma as the value delimiter).
Default and
- Ignore empty lines: false
- Allow missing column names: true
Format according to RFC4180.
- Delimiter:
, - Quote:
" - Record Separator:
\r\n - Ignore Empty Lines: false
Tab-delimited format.
- Delimiter:
\t - Quote:
" - Record Separator:
\r\n - Ignore surrounding spaces: true
Default MySQL format used by the SELECT INTO OUTFILE and LOAD DATA INFILE operations.
- Delimiter:
\t - Quote: none
- Record separator:
\n - Ignore empty lines: false
- Escape:
\ - Null string:
\n
Default Informix CSV UNLOAD format used by the UNLOAD TO file_name operation.
- Delimiter:
, - Quote:
" - Record separator:
\n - Escape:
\
Default Informix CSV UNLOAD format used by the UNLOAD TO file_name operation (escaping is disabled.)
- Delimiter:
, - Quote:
" - RecordSeparator:
\n
This is a preset you can customize for your needs.
To do so select the Edit Custom Format entry from the top right menu.
Please note that if used the following parameters are not to be equal:
quote char & delimiter
escape char & delimiter
comment char & delimiter
quote char & comment char
escape char & comment char