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

Last updated on DECEMBER 08, 2015

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.6.x to 11.1.1.9.0 [Release 11.1]
Information in this document applies to any platform.

Goal

One generates a BI Publisher report in CSV output format.

Upon review of the CSV output, it is found that 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms