CSV (Comma Separated Value) Writer Parameters

Output File Parameters

Fields

Encoding

Advanced

Unsafe Characters

Several of the parameters below reference “unsafe” characters. These are characters that could cause the output file to be misinterpreted when present in an attribute value. Here are some examples of unsafe characters:

Character Type

Example

Delimiters

An attribute whose value is abc,def would be interpreted as two fields when read back, rather than one.

Leading field qualifiers

An attribute whose value is “abc would cause all values after that to be interpreted as part of the same value if there was no closing field qualifier.

Newlines

An attribute whose value is

abc

def

would be interpreted as two separate lines.

By default the writer will enclose values that contain unsafe characters in the field qualifier character, which should allow them to be interpreted correctly. However, there are options to adjust this handling.