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.