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

User_0ONK7

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?

Sumanth V -Oracle

@User_0ONK7 - Please confirm the application details you are using to assist further.

User_0ONK7

I am using Oracle Fusion application @Sumanth V -Oracle

Gianni Ceresa

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).

Dimple-Nagesh-Support-Oracle

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

Double post

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