My Oracle Support Banner

BI Publisher : Double Quotes Get Added To Some Values by Default When Generating CSV Output (Doc ID 2081010.1)

Last updated on APRIL 03, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.x to 12c [Release 11.1 to 12.0]
Oracle Fusion Purchasing Cloud Service - Version 11.13.22.04.0 to 11.13.22.04.0 [Release 1.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
AAAAAA AAAAAA, BBBBBB AMERICAN

In the CSV output, it shows:

NAME,DISPLAY_NAME,LANGUAGE

ABBBB,"AAAAA, BBBBB", 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.