<delimited-file>

Fields in the data file are separated by a delimiter character.

Delimited File

start-row

Row from which to start loading. For example, start-row="2" tells the loader to skip the first row. (Default=1)

end-row

Row after which to stop loading. (Default=end of file or first empty row)

treat-missing-trailing-fields-as-null

Whether to treat missing trailing fields (files with fewer fields than defined in the load specification) as null values instead of errors. (Default=false)

charset

Character set used by the data file. Generally defined only for files that use a character set different from that of the computer on which the loader is running. (By default, the character set is not specified.)

row-increment

Number of rows between each record in the file. Generally defined only for files containing multiple data pivots. (Default=1)

delimiter

Required: For comma-delimited files, set delimiter=",". For tab-delimited files, set delimiter="&#9" where &#9 is the XML character denoting a tab. (You cannot use a tab character because tabs may be stripped away by XML parsers.)

text-qualifier

Characters between which to qualifiy text. Delimiters are treated as normal characters inside qualified text. The most common text qualifier is the double-quote; for example, text-qualifier="&quot"" where &quot is the XML character denoting a double-quote. (By default, text is not qualified.)