csvImportOptions
0
0
365
128
Form
-
<p>Enable this if the first data line in your CSV file represents column names. You don't want column names to be imported into the table as a regular data.</p>
First line represents CSV column names
CsvImport.FirstRowAsColumns
-
CsvImport.Separator
-
, (comma)
-
; (semicolon)
-
\t (tab)
-
(whitespace)
-
Custom:
-
Column separator:
-
If enabled, then text value provided on the right will be interpreted as NULL
NULL values:
CsvImport.NullValues
-
If your CSV data contains null values, define how are they represented in the CSV.
CsvImport.NullValueString
-
30
16777215
CsvImport.CustomSeparator
-
<html><head/><body><p>If enabled, the " character will be interpreted as standard CSV value quotation mark, causing the string to be treated as single value until the next (ending) " character. If disabled, the " will be treated as any other character. Usually you want this to be enabled.</p></body></html>
Interpret " as a value quotation mark
CsvImport.QuotationMark