CSV (Comma Separated Value) Writer Parameters
Output File Parameters
Enter the file name extension for the output file. The default is .csv.
This option is used only when adding a new writer and serves to provide a default value for any feature types associated with this writer, setting the option with the same name.
- Yes: Existing files will be overwritten if a matching CSV file was found in the destination folder.
- No: Rows will be appended to existing files if a matching CSV file was found in the destination folder.
Fields
The single-character or tab character specified as the delimiter between values. The default is the comma character.
Specifies whether to write a row containing the field names to the output file.
When this is set to If Writing First Row, the field names will only be written when writing a new file (that is, Overwrite Existing File is set to Yes, or it is set to No and there is no existing file).
Encoding
By default, the writer produces UTF-8 encoded documents.
If this parameter is set to another encoding, the writer will transcode the data to the selected encoding.
Specifies whether the byte order mark for a UTF-encoded file should be written at the beginning. This option applies only when the character encoding is set to a UTF encoding.
Advanced
Specifies whether the field names written on the first row of the file are quoted.
- Yes: Field Names will be quoted.
- No: Field names will not be quoted.
- If Needed: This is the default choice. Field names will be quoted if they contain one or more delimiter or quote characters.
Specifies whether the field values should be qualified (that is, enclosed in field qualifier characters).
- Yes: Every field, including Field Names, is quoted.
- No: Zero fields are quoted.
- If Needed: This is the default choice. Values will be quoted if they contain one or more delimiter or quote characters.
Specifies the character that encloses field values. The default is the quotation mark character.
When a field starts with this character, all text that follows this character and precedes the next occurrence of the character will be treated as one value, even if that text contains a delimiter or newline character.
Specifies the character that escapes the field qualifier character.
This is used when you want to have a field qualifier literal within a field qualifier group.
Specifies end-of-line character to use.
Note that this will only be used to terminate rows, and that individual values that contain newline characters will not be modified to conform to this option.
A schema configuration file contains formatting information about text files located in the same file directory. These files are always named schema.ini and contain information about field names and types, the field separation character, and more. This file can be used when loading table data into ArcGIS. See https://msdn.microsoft.com/en-us/library/ms709353(v=vs.85).aspx for more details.
- When this option is checked, schema configuration file is created along with the output CSV file(s).
- When this option is unchecked, a schema configuration file is not created.
Existing Schema File Handling
Specifies whether entries will be prepended to an existing schema file if one already exists.
- Overwrite: Overwrite the existing schema.ini files, if any are present.
- Prepend: If a schema.ini file already exists in the output directory, prepend new information to the existing file.
Note: Entries will not be added to the schema.ini file when appending to an existing .csv file (that is, Existing File Handling is set to Append, and the file already existed). It is assumed in this case that the schema file already has an entry for the corresponding .csv file.
Note: ArcGIS will only take into account the first config entry encountered for each CSV file, meaning the latest entries should be at the top of the file (this is why prepend is preferred over append).