Skip to content

filter.csv-to-xml.format (collection.cfg setting)

Description

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

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

See also

top

Funnelback logo
v15.16.0