Output File Parameters
Extension
Enter the file name extension for the output file. The default is .csv.
Append to File
This parameter specifies whether rows will be appended to existing files if a matching CSV file was found in the destination folder.
Output Field Names on First Line
If selected, the field names will be written to the first line of the output file as column titles.
Schema Configuration File
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.
Write Schema Configuration File
- Yes: A schema configuration file is created along with the output CSV file(s).
- No: A schema configuration file is not created.
Prepend to Existing Schema Configuration File
- Yes: If a schema.ini file already exists in the output directory. Prepend new information to the existing file.
- No: Overwrite existing schema.ini files, if any are present.
Note: The “Prepend to Existing Schema Configuration File” parameter only applies if the “Append to File” parameter is set to “No”. If the “Append to File” parameter is set to ‘Yes’ and a schema.ini file exists in the output directory, the schema.ini file will not be modified, regardless of the value of “Prepend to Existing Schema Configuration File” parameter value.
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, which is why prepend is preferred over append.
Field Separation
Separator Character
The single character or tab character specified as the separator for the values on a line.
Encoding
Character 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.
Write UTF Byte Order Mark
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.
File Contents
Quote Output Values
- Yes: Every field, including field names, is quoted.
- No: Zero fields are quoted.
- if_needed: This is the default choice. Values are quoted if they contain one or more delimiter or quote characters.
Quote Field Names
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.
Line Termination
Choose the end of line character to use when writing. If not specified, this parameter defaults to the system encoding.