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!