Specifies the format to use when parsing all CSV files.

データ型

string

デフォルト値

"CsvDelimited"

解説

When this connection property is set, the 本製品 parses all CSV files in the URI according to the specified file format:

• CsvDelimited: The 本製品 separates each field by commas.
• TabDelimited: The 本製品 separates each field by tabs.
• FixedLength: The 本製品 counts a specified number of characters to separate each field. Requires you to also set the width of each column 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=||