EscapeChar option

Specifies the use of an escape character.

The character immediately following the '\'value is escaped. The only supported value is '\', and the default is no escaping.

By default, the system expects fields to be delimited by a field-delimiter character or by an end-of-row sequence. The system assumes that all other characters are part of the value of the field. Although efficient, this representation has the drawback that string fields might not contain instances of the field delimiters. In addition, one value typically becomes inexpressible because you use it to convey the absence of any value (that is, that the column is null).

One solution is to use an escape character for the delimiter. The following command line example demonstrates the use of the EscapeChar option:

nzload -escapeChar '\' -nullValue 'NULL' -delim '|'

The command has the following effects:

|NULL| is a null input field.
|\NULL| is a non-null input field that contains the text NULL.
|\|| is a non-null input field that contains the single character |.
|\\| is a non-null input field that contains the single character \.

This option is not supported for the fixed-length format.