Hi All,
If we create any Publisher report and try to view or download it in .csv format, Fields which has data with more than one word comes in double quotes. If data has single word, it comes with out any quotes and looks correct.
If we view it in excel or XML data looks good with out any quotes and did not observe this behavior.
Version: 11.1.1.5
Steps to Replicate:
1. Create a simple data model as select * from scott.dept
2. Create a blank layout and report on top of it to view data.
Note: Varchar Fields if has more than one word, it comes in quotes else for single word it look ok.
Sample:
DEPTNO,DNAME,LOC
10,ACCOUNTING,"NEW YORK"
20,RESEARCH,DALLAS
30,SALES,CHICAGO
40,OPERATIONS,BOSTON
Let know if anything missed from my end. Any pointers or suggestions would be appreciated.