CSV properties

New line character type: This defines the type of new line character, chosen between the current platform, Windows, UNIX / Mac OS X, Classic Macintosh style and an explicitly-specified character.

New line character: If you choose to explicitly define a new line character, do so here.

Delimiter: This defines the character used to separate values.

Skip header reading: Select this checkbox to skip the first line, which is useful when the first line is a header. Note that if no header is present, selecting this checkbox will skip the first line of data.

Skip header writing: Select this checkbox to skip the first line when printing a CSV file.

Generate default header: Select this checkbox when there is no header in the file to generate default header values by concatening 'Col_' with the position index of the column (e.g. 'Col_1', 'Col_2', 'Col_3', and so on).

Quote mode: This option defines how quotes should behave when printing, and has five possible values: None (no quote mode defined), All (quotes all fields), Minimal (quotes fields which contain special characters such as a delimiter, quotes character or any of the characters in line separator), Non-numeric (quotes all non-numeric fields) and Never (never quotes fields).

Quote charatcer: This lets you specify the character to be used as value encapsulation marker. It can be left undefined (empty value).

Comment start character: This lets you specify the character used for comment identification. It can be left undefined (empty value).

Escape charatcer: This lets you specify the character used to escape special characters in values. It can be undefined (empty value).

Ignore surrounding spaces: Select this checkbox to ignore whitespaces that enclosing values.

Ignore empty lines: Select this checkbox to skip empty lines.

Trim: This lets you trim leading and trailing blanks.

Character encoding: This lets you specify the charset used to encode/decode the characters in the CSV file.