CSV File Connection
Access level: read, write
Jedox Integrator can import or export CSV (comma-separated-value) files.
With Jedox 24.2, PGP decryption is supported for file-based connections, such as
Connection settings
Type |
The following file location types are supported:
|
File / directory name | Path to the CSV file or directory containing CSV files. The syntax of the file name is location-specific. |
CSV Settings
Header | If set, the entries of the first line of source data are used as column headers. |
Data delimiter | Separators between the columns in the text file, e.g. ",".
Any other character is also valid. |
Enclosure character | The enclosure character of the columns. Possible enclosure characters are:
If no enclosure character is defined, by default double quotes (") is used. |
Encoding |
The most common 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 |
Use escape character |
If set, the character “\” invokes an alternative interpretation of the subsequent character. |
Updated September 27, 2024