How can I extract data in csv format with all string/text fields double quoted n double quotes escap

Question

I want to create a data extract in csv format with all string/text fields double quoted and double quotes escaped, how can I do this?

Gianni Ceresa · Answer

Double post

https://community.oracle.com/products/oracleanalytics/discussion/24050/report-with-all-text-fields-double-quoted-and-double-quotes-escaped

Dimple-Nagesh-Support-Oracle · Answer

Hi @User_0ONK7,

Please check if you want to use eText Templates:

Introduction : An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer. Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data.

More details on : https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T421739T481436.htm

Thanks,

Dimple N

Gianni Ceresa · Answer

Hi @User_0ONK7 ,

You are using Fusion, ok.

But in what part of Fusion are you working? What does the screen you are using looks like.

This forum is for Oracle Analytics products. You are maybe not even in the right forum, but right now it's impossible to know. Keep in mind that what sounds obvious for you because you are trying to do it for some hours or days, is totally unknown to us on the other side of the screen.

The more details you provide, the more chances to have a correct answer you have. Or to be given a link to a forum that can better assist you (Fusion as a product is covered in a parallel forum than this).