filter.csv-to-xml.format

Sets the CSV format to use when filtering a CSV document.

Key: filter.csv-to-xml.format
Type: CSVOptions allowed values: RFC4180_SKIP_EMPTY_LINES, RFC4180, EXCEL, TSV, MYSQL or MIME_TYPE
Can be set in: collection.cfg

Description

The following values may be set for this option:

  • RFC4180_SKIP_EMPTY_LINES: Process the CSV as RFC4180 skipping blank lines.

  • RFC4180: Process the CSV as RFC4180.

  • EXCEL: Process the CSV in the format Excel exports. Some regional settings may cause issues. You may be required to transform Excel CSV to RFC4180 before the CSVToXML filter is run.

  • TSV: Process the document as tab separated values.

  • MYSQL: Process the CSV in format generated when MySQL exports to a CSV file.

  • MIME_TYPE: Process the CSV using one of the previously listed formats based on the mime type of the document. If the mime type is text/csv then RFC4180_SKIP_EMPTY_LINES will be used. If the mime type is text/tab-separated-values then TSV will be used.

Default Value

filter.csv-to-xml.format=MIME_TYPE

Examples

To interpret documents as MySQL style CSV.

filter.csv-to-xml.format=MYSQL