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:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?