@exasol/exasol-driver-ts
    Preparing search index...

    Interface CsvFormatOptions

    Options for CSV file import. See https://docs.exasol.com/db/latest/sql/import.htm#Usagenotes

    interface CsvFormatOptions {
        columnDelimiter?: string;
        columnSeparator?: string;
        encoding?: Encoding;
        null?: string;
        rowSeparator?: RowSeparator;
        skip?: number;
        trim?: TrimMode;
    }
    Index
    columnDelimiter? columnSeparator? encoding? null? rowSeparator? skip? trim?
    columnDelimiter?: string

    Defines the field delimiter for CSV files.

    By default, the double quote character " is used. You can specify any string as a delimiter, either as plain text ('"'), as a hexadecimal value ('0x09'), or as an ASCII abbreviation ('NUL', 'TAB', 'LF', 'CR', 'ESC').

    A plain text value is limited to 10 characters, which are automatically converted to the encoding set for the file with the ENCODING option.

    A hexadecimal value is limited to 10 bytes (not characters) and will not be converted.

    If you do not want to use any field delimiter, define an empty string ('').

    columnSeparator?: string

    Defines the field separator for CSV files.

    By default, comma is used.

    You can specify any string as a separator, either as plain text (','), as a hexadecimal value ('0x09'), or as an ASCII abbreviation ('NUL', 'TAB', 'LF', 'CR', 'ESC').

    A plain text value is limited to 10 characters, which are automatically converted to the encoding set for the file with the ENCODING option.

    A hexadecimal value is limited to 10 bytes (not characters) and will not be converted.

    encoding?: Encoding

    Encoding of the CSV or FBV files.

    Default is UTF-8, an Encoding value.

    null?: string

    Additional representation of NULL values. This option is only supported for CSV files and only applies to fields not enclosed in field delimiters.

    Regardless of this option, an empty string in the input data always represents a NULL value.

    rowSeparator?: RowSeparator

    Defines the line break character.

    Default value: RowSeparator.LF

    skip?: number

    Number of rows that will be omitted in the import.

    This can be useful if you have to include header information within the data files.

    SKIP defines rows by line breaks (defined by ROW SEPARATOR) even if they occur inside data.

    trim?: TrimMode

    Defines whether spaces are removed at the border of CSV columns.

    Default: TrimMode.NONE (no spaces are removed)

    Settings
    Member Visibility

    On This Page
    Properties