RE: How to convince OText that whitespace = terminator -- Solved(

OK, not a lot of Text users out there...

I think I've solved my problem by removing "." from NUMJOINS and adding it to WHITESPACE (in the lexer, obviously).

It seems to work, anyway. :)

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

Disclaimer: Brett's LCL is only sprained! Consecutive start #165 in 2 weeks!

> -----Original Message-----
> From: Jesse, Rich
> Sent: Monday, October 21, 2002 3:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How to convince OText that whitespace = terminator
>
>
> I think the subject says it all, but here's the details:
>
> 1) Oracle 8.1.7.4 on HP/UX
> 2) Standard Oracle Context/Intermedia/Text index (e.g. no
> special lexers)
> 3) A column with values "12345 678", "12345.678", and "12345-6 789".
>
> Is there a way to setup the index or the query to return tbe
> first two rows
> without the third using a single CONTAINS clause? For example:
>
> SELECT *
> FROM my_otext
> WHERE CONTAINS(my_col,'12345 678')
>
> only returns the first row,
>
> SELECT *
> FROM my_otext
> WHERE CONTAINS(my_col,'12345%678')
>
> only returns the second, and
>
> SELECT *
> FROM my_otext
> WHERE CONTAINS(my_col,'12345/&678')
>
> returns all three. I would like a combo of the first and
> second SELECTS but
> in a single CONTAINS.
>
> I *know* this can be done, but I'm having a brain-cramp
> Monday. Must be
> lack of beer.
>
> TIA,
> Rich
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
> Disclaimer: Brett has a torn LCL, but should be in against
> Miami. Go #4! :D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).