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
Suggested Uses: For further processing in a database application.
This format type can be imported into applications, such as Excel
- This format
type does not create a Master File.
- Bursting is
- 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 (" ").
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.