Skip to main content

Delimiter is

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


delimiter is char


Argument Description


Specifies a single character from the 127 ASCII characters.

Additionally, the following values can be used:

Optional values
Value Description


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.


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

Learn more