Content tab

Content tab in S3 File Output

The Content tab allows you to include additional descriptive fields in the result set.

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 property.
Header	Clear to indicate that the output text file does not have a header row (first line in the file).
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. Only one file is placed in a single archive. The default value is None.
Encoding	Specify the text 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 text file by not including any formatting information.
Split every ... rows	Specify to split the resulting text 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.