The Content tab contains the following options for
describing the content written to the output text file:
| Option | Description |
|---|---|
| Append | Append lines to the end of the specified file. |
| Separator | Specify the character that separates the fields in a single line of text. Typically, it is a semicolon (;) or a tab. Click Insert TAB to place a tab in the Separator field. |
| Enclosure | Enclose fields with a pair of specified strings. It allows for separator characters in fields. This setting is optional and can be left blank. |
| Force the enclosure around fields? | Force all field names to be enclosed with the character specified in the Enclosure property. |
| Header | Indicate if the output text file has a header row (first line in the file). |
| Footer | Indicate if the output text file has a footer row (last 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. |
| Compression | Specify the type of compression (ZIP or GZIP) to use when compressing the output. Only one file is placed in a single archive. |
| 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 | Add spaces to the end of the fields (or removes characters at the end) until the length specified in the table under the Fields tab is reached. |
| Fast data dump (no formatting) | Improve the performance when dumping large amounts of data to a text file by not including any formatting information. |
| Split every ... rows | If the number N is larger than zero, split the output text file into multiple parts of N rows. |
| Add Ending line of file | Specify an alternate ending row to the output file. |