Categories
- All Categories
- 72 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 39 Oracle Analytics Trainings
- 58 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Report with all text fields double quoted and double quotes escaped
We have a requirement to extract data with all string/text fields double quoted and double quotes escaped. How can we best accomplish it? May be in the e-text template?
Answers
-
This is in Oracle Fusion Application - BI Publisher
0 -
Hi @User_0ONK7,
Here is the documentation for Creating 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 N0 -
What is the type of output file txt or csv?
Attached document should help.
BI Publisher : Double Quotes Get Added To Some Values by Default When Generating CSV Output (Doc ID 2081010.1)
Thanks.
0 -
@User_0ONK7 ,
Please do not double post, mostly when not adding much compared to the existing question.Will close the original thread as this one has the same replies for Publisher.
0
