FieldSeparator Property

The FieldSeparator property sets or returns the type of field delimiter used in a data source.

Syntax

FlatFileDataSource .FieldSeparator

Applies To

FlatFileDataSource Object

Discussion

Use this property to specify the character that acts as the field delimiter in a data source. Transformer examines only the first byte in double-byte and multi-byte characters to determine whether a character in the input stream matches the delimiter character you specify.

This property only applies to flat files with SourceType property set to trFlatFile or trFlatFileColumnNames.

Standard delimiters, such as the comma, semicolon, or space character, remain the same across character sets. If the source data is rendered in the DOS Code Page character set (OEM), Transformer converts the delimiter character to the OEM character set.

Type

String

Access

Read/Write

Examples

objDataSource 
= objModel.DataSources.
   Add(xtrObjectType.trFlatFileDataSource)objDataSource.FieldSeparator
= ","