My Oracle Support Banner

BI Publisher Adds Double Quotes to Some Values by Default When Generating CSV Output (Doc ID 2081010.1)

Last updated on DECEMBER 01, 2018

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.6.x to 12c [Release 11.1 to 12.0]
Information in this document applies to any platform.
Reviewed for Relevance 1 Dec 18.

Goal

Generate a BI Publisher report in CSV output format.

Upon review of the CSV output, BI Publisher added Double Quotes to some values by default.

For example:

In Report other than CSV format, it shows:

NAME DISPLAY_NAME LANGUAGE
AYANDI ANDY, WANG AMERICAN

 

In the CSV output, it shows:

NAME,DISPLAY_NAME,LANGUAGE

AYANDI,"ANDY, WANG",AMERICAN

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.