Delimiter

For delimited table files, an arbitrary delimiter can be specified through the delimiter is specifier. This specifier is relevant only for delimited .txt files.

Syntax:  

delimiter is char

Arguments:  

Argument Description

char

Specifies a single character from the 127 ASCII characters.

Additionally, the following values can be used:

'\t'

representing a tab sign, with or without quotation marks.
'\\' representing a backslash ( \ ) character.
'spaces' representing all combinations of one or more spaces. Non-printable characters with an ASCII-value below 32, with the exception of CR and LF, will be interpreted as spaces.

If nothing is specified, delimiter is ',' is assumed.

Example:  

LOAD * from a.txt (utf8, txt, delimiter is ',' , embedded labels);

See also: