Flat File Export Tab

Export file. Specifies the name of the file. Enter a filename or click the file chooser button to browse to the file's location.

Write mode. If Overwrite is selected, any existing data in the specified file will be overwritten. If Append is selected, output will be added to the end of the existing file, preserving any data it contains.

  • Include field names. If this option is selected, field names will be written to the first line of the output file. This option is available only for the Overwrite write mode.

New line after each record. If this option is selected, each record will be written on a new line in the output file.

Field separator. Specifies the character to insert between field values in the generated text file. Options are Comma, Tab, Space, and Other. If you select Other, enter the desired delimiter character(s) in the text box.

Symbol quotes. Specifies the type of quoting to use for values of symbolic fields. Options are None (values are not quoted), Single ('), Double ("), and Other. If you select Other, enter the desired quoting character(s) in the text box.

Encoding. Specifies the text-encoding method used. You can choose between the system default, stream default, or UTF-8.

  • The system default is specified in the Windows Control Panel or, if running in distributed mode, on the server computer.
  • The stream default is specified in the Stream Properties dialog box.

Decimal symbol. Specifies how decimals should be represented in the data.

  • Stream default. The decimal separator defined by the current stream's default setting will be used. This will normally be the decimal separator defined by the computer's locale settings.
  • Period (.). The period character will be used as the decimal separator.
  • Comma (,). The comma character will be used as the decimal separator.

Generate an import node for this data. Select this option to automatically generate a Variable File source node that will read the exported data file. See the topic Variable File Node for more information.