Convert HTML to RTF

[IanWaterman]

We are using Crystal Reports with Oracle 9i. We are storing HTML to display users custom formatted text. Unfortunately the HTML interpreter within Crystal is very limited and does not recognise html like blockquote, <ol>, <ul> etc.

A possible work around is to create a view which converts the html into rtf, as Crystal can display rtf without any limitations

Does any one know of any functions or bespoke SQL that can do this.

Thank you

Ian Waterman

 

[r937]

this is not really an SQL problem

at best, you would use a data format conversion utility to translate the html page to rtf, then store the rtf in a BLOB column in the database

but that conversion is not done with SQL

r937.com | rudy.ca