Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to CSV without double quotation (") Enclosed By

177437Mar 11 2008 — edited Mar 11 2008
I would like to export a report to a .csv file without any added separators or delimiters. We pre-format the data for the export, and that data then gets imported into another system. The report has all of the necessary comma separators. The exported output should look like this:

START_HEADER,
Overriding Approver,
Comments,These are comments
STOP_HEADER,
START_TEMPLATE,,,,,,,,,,,,,,,,,,,,
rest of file...

The commas are just where we want them and we do not want any double quotation marks added. The Report Export region in APEX wants to default a comma for the Separator and a double quotation for the Enclosed By. We don't want either.

Any ideas on how to get rid of both defualt values?
Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Mar 11 2008
1 comment
787 views