Content tab

The Content tab allows you to include the following options for the output text file.
Option
Description
Append
Select to append lines to the end of the file.
Separator
Specify the character used to separate the fields in a single line of text, typically a semicolon or tab. Click Insert Tab to place a tab in the Separator field. The default value is semicolon (;).
Enclosure
Specify to enclose fields with a pair of specified strings. It allows for separator characters in fields. This setting is optional and can be left blank. The default value is double quotes (").
Force the enclosure around fields?
Specify to force all field names to be enclosed with the character specified in the Enclosure option.
Disable the enclosure fix?
Specify to disregard enclosures on string fields and separators.
Header
Clear to indicate that the first line in the output file is not a header row.
Footer
Select to specify that the last line in the output file is a footer row.
When using the Append option, it is not possible to strip a footer from the file content before appending new rows.
Format
Specify the type of formatting to use. It can be either DOS or UNIX. UNIX files have lines separated by line feeds, while DOS files have lines separated by carriage returns and line feeds. The default value is CR + LF (Windows, DOS).
Compression
Specify the type of compression (.ZIP or Gzip) to use when compressing the output file. Only one file is placed in a single archive. The default value is None.
Encoding
Specify the file encoding to use. Leave blank to use the default encoding on your system. To use Unicode, specify UTF-8
or UTF-16
. On first use, PDI searches your system for available encodings.
Right pad fields
Select to add spaces to the end of the fields (or remove characters at the end) until the length specified in the table under the Fields tab is reached.
Fast data dump (no formatting)
Select to improve the performance when dumping large amounts of data to a file by not including any formatting information.
Split every ... rows
Specify to split the resulting file into multiple parts of N rows if the number N is larger than zero.
Add Ending line of file
Specify an alternate ending row to the output file.
Last updated
Was this helpful?