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.
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.
Exporting Report to CSV
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