A script-enabled browser is required for this page to function properly.

About delimited output

Oracle Reports can generate report output that includes a delimiter to delimited files (for example, files that contain comma-separated or tab-separated data), which are easily imported into spreadsheets or for use with word processors.

Oracle Reports provides two choices for generating delimited output:

You can specify a delimiter (a character or string of characters) to separate the data (boilerplate or field objects) in your report output in either of the following ways:

Note: If you do not specify a delimiter, the default delimiter is a tab.

You can further distinguish the cells by using a cell wrapper.  A cell wrapper can consist of any series of characters, such as a comma or parentheses.

For example, if the data in your report output includes the same character as the delimiter (for example, a comma), you can use the parentheses cell wrapper to distinguish each cell:

(1,000,000),(3,6000),(543),(2,003,500)…

Usage notes

DelimitedData output

When you generate a report to DelimitedData output, only data (as defined by the report data model) displays in the output. Any formatting changes defined in the layout are not reflected in the DelimitedData output.

You can set the following column properties to alter column names and exclude columns from the DelimitedData output file:

To generate report output that preserves the report layout information, see About spreadsheet output.

Delimited output

When you generate a report to Delimited output, the data displays according to the positions of the objects in the Paper Layout view.

graphic depicting delimited output described above

graphic depicting delimited output described above

graphic depicting delimited output described above

graphic depicting delimited output described above

Restrictions

See also

Generating delimited output

About spreadsheet output

Running and dispatching a report from the user interface

About fields

About matrix objects