Format: COMMA (.csv)
Description: 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
- Can be opened
in the Report Library with Excel, or you can open COMMA reports
in Lotus 1-2-3 by right-clicking the report and saving it as a COMMA
file outside of the Library.
- 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.