Delimiters Tab

The following list describes the properties on the Variable Length Delimited Data Properties Delimited tab:

Use defaults

Selects all of the default delimiter settings.

Include column (field) names from first record

On the input side, specifies that the first record is a header (therefore the information in it will not be processed as data).

On the output side, instructs the translator to create a header record in the output file.

Field Delimiter

Character that separates fields.

Quote Character

Character that quotes fields.

Quote fields containing delimiter (default)

Output side only. Specifies that only fields that contain the delimiter are quoted.

Quote text fields and fields containing delimiter

Output side only. Specifies that all string fields and all fields that contain the delimiter are quoted.

Quote all fields

Output side only. Specifies that all fields are quoted.