Handling CLOB data in Oracle Analytics Cloud(OAC) and BI Publisher

Question

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 / [
] 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:

Gianni Ceresa · Answer

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?