DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2000
    Does anyone have a PL/SQL function or procedure that will turn RTF formatted data into plain text? I have found a dos program that will do it, but I was hoping to have some PL/SQL code that can do it... anyone?



    (I originally posted this in the dba forum, but I think here is more appropriate. sorry for the crosspost)

  2. #2
    Join Date
    Nov 2000
    I don't have a PL/SQL program, but I know you can do that with MS Word. Maybe there's a way to do it using a Word Macro.

    Just a thought.



  3. #3
    Join Date
    Nov 2000

    Here is my problem.

    I have a table with a column that is type LONG. It has data in it that is in the rtf format. I want to be able to view the data in the long column in a report, but the reporting program can't translate rtf, so what I wanted to do was the following :

    1) build a function like this -
    function rtf_to_text(rtfdata varchar2) returns varchar2

    2) build a view that uses the function, to give the appearance
    of having a 'regular text' version of the table.

    Another less preferred way I think I can pull this off is to use a microsoft API - call it via a library. But then my code is platform specific, so I am hoping to avoid this. Not to mention then I would have to use external procedures.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.