Convert Text to RTF (Rich Text Format)

[AndrewD]

I have data stored in a Clob column and it is stored in a plain text format. It contains RTF tags (for Bold, Itallic, Underline, Font Size, etc.) within the text, that are rendered properly within the "Large Data Editor". I need to automate the export and not just save each clob one column at a time because there are 1200 of them. Is there a way to export the rendered RTF from the Large Text Editor so I can open it in MS Word and it will look correct?
Note: I've tried to open and save as RTF directly in word but word does not recognize this form of RTF. Please Help.
Thank you.

 

[Marco Kalter]

Do the CLOB contents start with an RTF header? Like this:

{\rtf1....

 

[AndrewD]

Yes they do. This is what the first line looks like:
{\rtf1\mac\deff3{\fonttbl{\f3\fswiss Geneva;}}

Can you help?

 

[Marco Kalter]

MS Word recognizes this header just fine for me. What exactly goes wrong?

 

[AndrewD]

The problem is that the only way I have been able to render the RTF correctly in word is to open an individual CLOB document in the Large Object Editor, select the RTF Tab, then save it. After that, then Word opens it correctly.

Word won't render the RTF from the text, even when I open in word and save as RTF.

Since I have 12000+ records, I can't cut and paste every one. So I wanted to know, can PL/SQL Developer can be configured to export all 12000+ CLOBs in their RTF format?