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!

Interactive Report CSV Export with blank delimiter

PaulPMar 25 2020 — edited Mar 26 2020

APEX 19.2

I need to export the results of an IR report as a pipe delimited csv with NO "enclosed by" characters for import into a 3 party system with strict formatting. The format is as follows:

abc|123|a1b2b3|...

def|456|d4e5f6|...

...

I have the pipe "|" working OK in the extract using the IR attribute "CSV Separator" but how do I EXCLUDE double quotes, the default for blank "CSV Enclosed By" attribute?

If there is no solution then is the solution in this link the best way to do it? https://www.foxinfotech.in/2019/09/oracle-apex-download-csv-using-pl-sql-procedure.html

Would be helpful to be able to do this out of the box.

pastedImage_0.png

Comments
Post Details
Added on Mar 25 2020
3 comments
1,370 views