COMT

Format: COMT (.csv)

Description: Adds titles to a COMMA file. Saves scheduled output as a variable-length text file in comma-delimited format with character values enclosed in double quotation marks (" "). All blanks within fields are retained.

This format is required by certain software packages, such as Microsoft Access.

Suggested Uses: For further processing in a database application. This format type can be imported into applications, such as Excel or Lotus.

Considerations:

• This format type does not create a Master File.
• Bursting is supported.
• Cannot be opened in the Report Library with Excel.
• Smart date fields and dates formatted as I or P fields with date format options are treated as numeric and are not enclosed in double quotation marks (" ") in the output file. Dates formatted as alphanumeric fields with date format options are treated as alphanumeric and enclosed in double quotation marks (" ").
• Continental decimal notation (CDN=ON|SPACE|QUOTE) is not supported. A comma within a number is interpreted as two separate columns by a destination application, such as Microsoft Access.
• When creating a ReportCaster schedule using the COMT format, you must check the Override the Format Specified in the Procedure check box and select the COMT format. Otherwise, the output may lose the CR/LF (Carriage Return / Line Feed) when producing the .csv file.