COMMA

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 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.
• 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 (" ").
• 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.