CGI and find

[Richard Gaskin]

J. Landman Gay wrote:

> All the "find" options are pretty useful. Suppose I am searching for
> "good dog":
> 
> find "good dog" -- finds any card which contains "good" and "dog" at the
> beginning of words, not necessarily together and not necessarily even in
> the same field. For example, will tag "goodly dogma" as a match but not
> "good underdog". Will tag "dog is good" as a match even though they are
> in a different order. Will tag a card if "dogma" is in one field and
> "good" is in another. This is hugely handy. For example, if I remember
> someone's first name and the city they live in, I can find them by
> seraching for "john san francisco" and even though the name and address
> are in different fields, the card will be found.
> 
> find whole "good dog" -- finds only the whole phrase, and only where the
> phrase is made up of whole words. I.e., won't find "good dogma". Similar
> to the "offset" solution, except that it won't tag matches if they
> aren't comprised of exactly the words in the search phrase.
> 
> find words "good dog" -- finds only whole words, but they can be in any
> order and not necessarily in the same field. Will tag a card as a match
> if one field contains "good eating" and another field contains "hot
> dog". Would not match if the second field contains "hot dogs" though,
> because "dogs" isn't the word we're looking for.
> 
> find string "goo do" -- I don't use this much because it takes too long.
> But it can be handy if you need to look for a specific sequence of
> characters, including the spaces and punctuation in the sequence. This
> one would not match "good dog", but would match "mr. magoo does it". The
> string does not have to be at the beginning of a word.
> 
> find chars "goo do" -- find each string of characters comprising each
> part of the search phrase. In other words, find any sequence of "goo"
> and any sequence of "do", not necessarily together and not necessarily
> at the beginning of words. Would tag "does magoo" as a match, even if
> the two words were in different fields. This variation is also
> time-consuming to run, but can be invaluable if you need to find partial
> strings that may be located in different fields anywhere on a card.

Most excellent description of the Find command I've come across yet.  Thank
you!

-- 
 Richard Gaskin 
 Fourth World Media Corporation
 Developer of WebMerge: Publish any database on any Web site
 ___________________________________________________________
 Ambassador at FourthWorld.com       http://www.FourthWorld.com
 Tel: 323-225-3717                       AIM: FourthWorldInc