One little note to Tom's answer, in fact you can convert to plain text without an index, using ctx_doc.policy_filter function (and according to docs IFILTER will be depricated). You can create simple policy using: begin ctx_ddl.create_preference('test_inso_filter', 'INSO_FILTER'); ctx_ddl.create_policy( 'test_policy', 'test_inso_filter' ); end; and than filter document to plaintext using begin ctx_doc.policy_filter( 'test_policy', l_blob, l_clob, TRUE ); end; On Wed, 8 Dec 2004 21:47:49 +0200, Edgar Chupit <chupit@xxxxxxxxx> wrote: > As allways Tom Kyte has answers to all questions (may be even to > purpose of meaning). > > His detailed example can be located here > http://asktom.oracle.com/pls/ask/f?p=4950:8:16271189729630420013::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:25695084847068, > or here http://tinyurl.com/5444t > > > > > On Wed, 8 Dec 2004 13:16:37 -0600, Jesse, Rich > <Rich.Jesse@xxxxxxxxxxxxxxxxx> wrote: > > I'd think there'd be a bunch of us that'd be interested in that, if it > > would be postable here... > > Rich > > > > > > > > -----Original Message----- > > Sent: Wednesday, December 08, 2004 12:54 PM > > Subject: Re: Rich Text formatted data > > > > You can use Oracle Text's CTX_DOC.FILTER to convert rtf into plain > > text or even into a html. Oracle Text supports more than 100+ file > > formats and one of the best things is that this feature is available > > even in Std. Edition We use this feature intensively in one of our > > app. > > > > If you need a test case/simple example, I can write one for you > > tomorrow in the morning. > > > > On Wed, 8 Dec 2004 11:55:41 -0500, Goulet, Dick <DGoulet@xxxxxxxx> wrote: > > > Anyone know how to convert a MicroSlop rich text, like a word doc, field > > > into just plain text? And using word in this case is not an option. > > > > > > Dick Goulet > > > > > > -- > > > > > > //www.freelists.org/webpage/oracle-l > > > > > -- > Edgar > -- Edgar -- //www.freelists.org/webpage/oracle-l