CSV file standards

When configuring ingest jobs and Secure FTP (SFTP) file transfers, keep in mind the following standards for CSV files.

Supported CSV standards

Oracle Unity supports the following CSV parsers:

  • Opencsv

    Ingests single line data.

  • RFC 4180

    Ingests single line and multi-line data.

Review the summary of specifications below for each CSV parser.

Parser Supports single-line data? Supports multi-line data? Field delimiters supported How double quotes (") are managed
Opencsv Yes No

  • Comma (,)

  • semicolon (;)

  • pipe (|)

  • tab ( )

 Individual fields may or may not be enclosed in double quotes. If double quotes are not used to separate data, data will be parsed with the delimiter. Special characters must be in double quotes.
RFC 4180 Yes Yes Comma (,) Multi-line data must be in double quotes. Single-line data may or may not be enclosed in double quotes.

Learn more

Opencsv file standards

RFC 4180 file standards

Sources API

csv file, csv, csv file standards, comma separated files