Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing RTF Tags From String

user580898Jun 19 2007 — edited Jun 19 2007
Using Oracle 9.2 and the following varchar2 string (extracted from BLOB), how can I remove the RTF Control tags, essentially converting to Plain Text?

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Verdana;}}
{\colortbl ;\red255\green0\blue0;}
\viewkind4\uc1\pard\f0\fs17 sample1
\par sample2
\par
\par sample3
\par 1. test1
\par 2. test2
\par 3. test3
\par
\par sample4
\par \cf0
\par sample5
\par }
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2007
Added on Jun 19 2007
4 comments
2,176 views