Skip to main content

Delimiter

ON THIS PAGE

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