On this page:
   35.21    Database 35.23    ETL Import: Source   

35.22ETL Import: CSV Properties

 

The ETL Import: CSV Properties configuration category includes the following configurable options:

  • CSV File Delimiter

  • Parse Quotes

35.22.1Property: CSV File Delimiter

 
Property Name CSV File Delimiter
Property Key
Property Type STRING
Description For CSV import files, this setting defines the delimiter to use when parsing files. Escape special characters with ''. E.g. for tab, use . Note only one delimiter is supported.
Applies to Modules
  • ETL Importer
Default Value ,
Example Property
module.[MODULE_ID].config.csv.delimiter = ,

35.22.2Property: Parse Quotes

 
Property Name Parse Quotes
Property Key
Property Type BOOLEAN
Description If enabled, quoted values will be parsed per the rules specified in RFC 4180. If this is disabled, quoted values will be parsed verbatim (and any quote marks will be included in the parsed values).
Applies to Modules
  • ETL Importer
Default Value true
Example Property
module.[MODULE_ID].config.csv.parse_quotes = true
   35.21    Database 35.23    ETL Import: Source