My Oracle Support Banner

Double Quotes Missing In CSV Output When Comma and Spaces In The Output (Doc ID 2650411.1)

Last updated on APRIL 08, 2020

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

When exporting a BI Publisher report in CSV format that contains a comma or a space in the data value(s), the comma is not escaped correctly. The value is not enclosed in double quote - the Double Quotes " " are missing in the CSV file.


For example, assume that a field has "Lastname, Firstname" (such as fictitious name "Doe, John") in it and it is exported to CSV. The CSV file currently contains:
Field 1 value,Doe, John,Field 2 value

This is not correct per CSV specs. It should instead contain double quotes around Doe, John:
"Field 1 value","Doe, John","Field 2 value"

Same issue occurs when there are spaces in the field.

 


The problem is only relevant to CSV export. Exporting to a different format is irrelevant.


Changes

 Exporting Report to CSV

Cause

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
Symptoms
Changes
Cause
Solution
References


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