File (CSV) Connection

Jedox Integrator can import or export structured text files, known as flat files or CSV files (comma-separated-value files).

Settings

Location See Locations for File-based Connections.
File name Name of the file in CSV format. The syntax of the filename is location-specific. More info in article Locations for Filebased Connections.
CSV settings Header: If set, the entries of the first line are used as column headers.
Data delimiter: Separators between the columns in the text file, e.g. ",".
  • Tab as data delimiter: \t
  • For blank value (" ") as data delimiter: #space
  • semicolon
  • comma

Any other string is also valid.
Enclosure character: The enclosure character of the columns. Possible enclosure characters are:
  • #none (no enclosures)
  • double quotes (")
  • single quotes (')

If no enclosure character is defined, by default double quotes (") is used.
Encoding The most prevalent character encodings are UTF-8 (default), ASCII, and latin1 (Windows standard).

A list of all character codes can be found at http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html
From this list you can also enter manually a character code into the field ‘Encoding’. Note that this connection only supports file encodings as provided by the Java Runtime Environment.
Use escape character If set, the character “\” invokes an alternative interpretation of the subsequent character.
Example: “1\”Hello\”2” is interpreted as 1”Hello”2

Updated July 21, 2025