3 Replies Latest reply on Sep 13, 2015 5:41 AM by Karthik417

    Fields in Publisher report with .csv output comes in double quotes. How can we prevent it ?

    Karthik417

      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.