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, ASCII character 26, which otherwise denotes end-of-file, is disregarded and can be part of a field value.

It is relevant only for delimited .txt files.

Example:  

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