Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Handling CLOB data in Oracle Analytics Cloud(OAC) and BI Publisher

Hi,
I have a CLOB field in which one of the values has maximum of 18000 chars in my Oracle database. Basically, this CLOB field will have some notes, some links, or more than 1 link (using space / [\n] new line characters). So, now when I query this in OAC and export the report to an rtf template, the CLOB field is coming in multiple rows for a single record because of the space and new line characters being used in the CLOB field. How to resolve this either in OAC or BI Publisher.?
In the image below, the two links belong to name 'POC'. Since it has space between them, it comes in 2 rows. But it should come in as in the second image
Appreciate your help, Thanks!
Second Image:
Answers
-
Hi,
Just to clarify: are you asking only about Publisher? Or Publisher and also a "classic" analysis exported as Excel or a DV workbook exported as Excel?
0