FMT
The format used to parse all CSV files.
Data Type
string
Default Value
"CsvDelimited"
Remarks
When this connection property is set, the connector parses all CSV files in the URI according to the specified file format.
You can set the FMT to one of the following values:
- CsvDelimited: The connector separates each field by commas.
- TabDelimited: The connector separates each field by tabs.
- FixedLength: The connector counts a specified number of characters to separate each field. If this format is specified, the width of each column must be defined in Schema.ini.
The following connection string parses all CSV files in the folder specified in the URI as tab-delimited values with headers:
InitiateOAuth=GETANDREFRESH;URI=C:\mytsv;FMT=TabDelimited
If the property is set to anything other than the values specified above, the literal character of the specified input is read as the delimiter, for example:
InitiateOAuth=GETANDREFRESH;URI=C:\mypipdelimitedfile;FMT=||