how to store MS word rtf file huge text area content in the obiee column with same format/retrieve??

usersrekan

Hi All,

i have created a table with description column with data type Clob. where i need to store huge text data and paragraphs. when cut and paste the text data which cotains paragraphs from rtf file to obiee subject area column, its displaying as plain text.

I wanted to store the data in to the column the way rtf file contains data structure in to the obiee column, when i retrieve the data it has to display the same way the rtf format and also when getting into xml that column data in the same rtf way from BI publisher too? any ideas?

Thank you,

Joe

Gianni Ceresa

Hi Joe,

Isn't this the same as https://community.oracle.com/tech/developers/discussion/4485777/how-can-we-store-ms-word-rtf-content-data-in-to-the-oracle-database-without-missing-formats#latest ?

OBIEE is a web-based tool, if you want something to have a "format", it has to be HTML.

How you do store your source, it isn't an OBIEE issue, it's up to you to find the correct way to store data for your needs (and that's why your other thread was moved to database). If you want your source content to be displayed in an OBIEE analysis on screen with a format, store it with HTML formatting.

usersrekan

Hi,

so there is no way if we cut and paste the formatted content from rtf file to the obiee column, that will display same when we call back to rtf file? for user point of view, they wont know html coding.

Thanks,

Joe