No eof

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


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.


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

See also: