The table below describes options for configuring the name and format of the fields being written for CSV files.
| Column | Description |
|---|---|
| Name | Specify the name of the field. |
| Type | Select the field's data type from the drop-down menu or enter it manually. |
| Format | Select the format mask (number type) from the drop-down menu or enter it manually. See Common Formats for information on common valid date and numeric formats you can use in this step. |
| Length |
Specify the length of the field, according to the following field types:
|
| Precision | Specify the number of floating-point digits for number-type fields. |
| Currency | Specify the symbol used to represent currencies (for example, $ or €). |
| Decimal | Specify the symbol used to represent a decimal point, either a period (.) as in 10,000.00 or it can be a comma (,) as in 5.000,00. |
| Group | Specify the method used to separate units of thousands in numbers of four digits or larger, either a comma (,) as in 10,000.00 or (.) as in 5.000,00. |
| Trim type | Select the trimming method (none, left, right, or both) to apply to a string, which truncates the field before processing. Trimming only works when no field length is specified. |
| Null | Specify the string to insert into the output text file when the value of the field is null. |
| Get Fields (button) | Click to retrieve a list of fields from the input stream. |
| Minimal width (button) | Click to minimize the field length by removing unnecessary characters. If selected, string fields will no longer be padded to their specified length. |