CSV fields

CSV fields

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: Number: Total number of significant figures in a number. String: Total number of significant figures in a number. Date: Total length of printed output of the string. For example, 4 only returns the year.
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.