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 Audience Segmentation supports the following CSV parsers:
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 |
|
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. |