User manual

24 FileMaker Pro User’s Guide
Finding text and characters
Search for text in text fields, or in calculation fields that return a text
result.
Unless you search for phrases and exact matches, the field can
contain other values in addition to the one(s) you specify, and the
values can be in any order. For example, typing
hotel in a field
named Accommodation finds records for
Hotel, Discount Hotel, and
Hotel, Luxury.
Show all records again In Browse mode, choose Records
menu > Show All Records.
In Find mode, choose Requests menu >
Show All Records.
You don’t need to choose Show All
Records before performing finds.
FileMaker Pro always searches all
records in the tables you specify unless
you have narrowed the existing found
set.
Open another window in order to
perform different find requests on the
same data
Choose Window menu > New Window.
To find
Type this in
the field Examples
Words that start with
specific characters (works
with fields that use any
language except Japanese)
The characters. Chris Smith finds
Chris Smith, Smith Chris,
Chris Smithson, and Smith
Christenson
Words that start with
specific characters
(Japanese field only)
The characters
between = and *.
1 = * finds ,
, and
1 =Chris* =Smith*
finds Chris Smith, Smith
Chris, and Smith
To Do this
Words that contain specific
characters in a Japanese
field
The characters.
finds ,
, and
A phrase or sequence of
characters
The text, including
spaces and
punctuation, between
the double quotation
marks ( " ).
"Marten and Jones
Interiors" finds
Marten and Jones Interiors
but not Jones and Marten
Interiors
", Ltd." finds all
companies with " , Ltd. " in
the name, but not those
without the comma.
Words with one or more
unknown or variable
characters
One wildcard
character (@) for
each unknown
character.
Gr@y finds Gray and Grey
@on finds Don and Ron
but not Bron
Words with zero or more
unknown or variable text
characters in a row
* for all unknown
characters.
Jo*n finds Jon and John
J*r finds Jr. and Junior
*phan* finds Phan and
Stephanie
Digits in a text field A # character for each
digit.
# finds 3 but not 30
## finds 30 but not 3 or
300
Symbols or other non-
alphanumeric characters,
such as punctuation or
spaces
The characters,
including spaces and
punctuation, between
the double quotation
marks (").
"@" finds @ (or an email
address, for example)
"," finds records
containing a comma
" " finds three
spaces in a row
Words with accented
characters
The text, including
spaces and
punctuation, between
the double quotation
marks (").
"òpera" finds òpera but
not opera
(òpera without quotes
finds both òpera and
opera)
To find
Type this in
the field Examples