Skip to main content Skip to complementary content

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);

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!