🚀 go-pugleaf

In article <2sg5b0$22ln@te6000.otc.lsu.edu>,
Venkatesh Rao <eevnr@unix1.sncc.lsu.edu> wrote:
>Hi,
>     What is the best way to do a keyword search in a pc based database
>like clipper? 
>     I have a big database file ( about 40,000 records) with a character
>field of length 100. I would like to search for a particular string and
>display all the records that meet the search condition. 
>thank you in advance
>
>_/ Venkatesh Rao                _/   					_/

at least in db4 v1.5, you can use the '$' operator.  the manual calls it
the substring operator where:

a='i love dbase'
b='ve'
?b $ a 

dbase returns a .t. since 've' is a substring of 'i love dbase'

you just gotta remember that the first character string is the one being
compared to the second one, i.e. 'a$b' returns a true is a is either
identical to b or contained within b.  

warning, this might a rather a slow process...

btw, the manual also talks about the at() and substr() functions that also
work with substrings..."but the $ operator provides a basic test that is
useful in many search routines." (db4 lang. ref. manual p.1-14)

later days...

leo d.

--
------------------------------------------------------------------------------
 \ The above does not represent OIT, UNC-CH, laUNChpad, or its other users. /
   ------------------------------------------------------------------------