U.M. (Mac OS)

Working with information in records 4-23
Finding text
Keep these points in mind:
1 Searching for literal text takes longer than word searches. (See
“Indexing fields” on page 2-12.)
1 You can omit records when you define one or multiple requests. See
“Omitting records” on page 4-26.
To find this in a text field Type this in the field Example
Words that start with specific
characters
The specific characters Chris Smith finds Chris
Smith, Chris Smithson, and
Smith Christenson
A word that is part of a field’s
contents
An equal sign (=) before the
word
=John finds John and John
Smith (but not Johnson)
An exact word and nothing
else
Two equal signs (==) before
the word
==John finds John only
==John Smith finds
John Smith (but not
Smith John)
Exact matches on several
words in the same text field
An equal sign (=) before each
word in the search criterion in
that field
=Chris =Smith finds
Chris Smith or Smith Chris
(but not Christopher
Smithwick)
Words that vary by one or
more characters
One wildcard character (@)
for each unknown character
Gr@y finds Gray and Grey
Words that vary by more than
one character
The wildcard character (*)
for all unknown characters
McK*ie finds McKechnie and
McKenzie
Whole words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type the text,
including spaces and
punctuation, surrounded by
double quotation marks (").
"Marten and Jones
Interiors" finds Marten
and Jones Interiors but not
Jones and Marten Interiors
Partial words of literal text
(text exactly as it appears, but
regardless of uppercase or
lowercase)
Choose Literal text from the
Symbols list. Type
characters, punctuation, and
spaces exactly as they appear
in the file, surrounded by
double-quotation marks (").
Type the wildcard character
(*) to find text in the middle
of the literal text string.
*"son & Phillips" finds
Johnson & Phillips and
Paulson & Phillips
", " finds Boston, MA and
Markley Insurance, Inc.
Choose FileMaker Help Index from the or Help menu, and then type:
E symbols
?