User manual

Chapter 1
|
Using databases 25
Performing quick finds based on data in one field
You can perform quick finds based on field data without having to go
to Find mode. You can perform a find based on an entire field or a
selection of text within a field. For more information, see Help.
1. In Browse mode, select the text in a field you want to use for the
find.
2. Right-click (Windows) or Control-click (Mac OS) the selected
text. From the shortcut menu, choose
Find Matching Records.
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
.
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
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
Invalid characters ? Invalid characters display
as blank characters
Note To find the ?
character, search for “?”
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 ot her 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