Each format specification item defines a certain property of the table file:
fspec-item ::= [ ansi | oem | mac | UTF-8 | Unicode | txt | fix | dif | biff | ooxml | html | xml | qvd | qvx | delimiter is char | no eof | embedded labels | explicit labels | no labels | table is [tablename] | header is n | header is line | header is n lines | comment is string | record is n | record is line | record isn lines | no quotes |msq ]
Character set is a file specifier for the LOAD statement that defines the character set used in the file.
ansi | oem | mac | UTF-8 | Unicode | codepage is |
The table format is a file specifier for the LOAD statement that defines the file type. If nothing is specified, a .txt file is assumed.
txt | fix | dif | biff | ooxml | html | xml | qvd | qvx
For delimited table files, an arbitrary
delimiter can be specified through the delimiter
is specifier. This specifier is relevant only for delimited
delimiter is char
Specifies the header size in table files. An arbitrary header length can be specified through the header is specifier. A header is a text section not used by QlikView.
Header is line
Header is n lines
If you have lines in your source data file that are comments, you can define a comment prefix with Comment is. Set
Comment is commentprefix
embedded labels | explicit labels|no labels
The no eof specifier is used to disregard end-of-file character when loading delimited .txt files.
Quotes is a file specifier for the LOAD statement that defines whether quotes can be used and the precedence between quotes and separators. For text files only.
For fixed record length files, the record length must be specified through the record is specifier.
Record is line
Record is n lines
This script specifier is used when loading
pattern is path