No eof

The no eof specifier is used to disregard end-of-file character when loading delimited .txt files.

Syntax:  

no eof

 

If the no eof specifier is used, characters with code point 26, which otherwise denotes end-of-file, are disregarded and can be part of a field value.

It is relevant only for delimited text files.

Example:  

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

See also: