Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 109
• To delete recent finds, click the down arrow next to Find or click Saved Finds (Windows),
or click and hold Find or click Saved Finds (OS
X). Then choose Clear All Recent Finds
from the list.
• In Find mode, a badge indicates a searchable field.
Related topics
Finding text and characters
Finding numbers, dates, times, and timestamps
Finding ranges of information
Finding data in related fields
Finding empty or non-empty fields
Finding duplicate values
Finding records that match multiple criteria
Finding records except those matching criteria
Viewing, repeating, or changing the last find
Hiding records from a found set and viewing hidden records
Constraining (narrowing) a found set
Extending (broadening) a found set
Finding records troubleshooting
Finding records based on criteria in a single field
Saving a find request
Managing saved find requests
Specify Find Requests and Edit Find Request dialog boxes
Finding text and characters
You can search for text in fields of type text, or in calculation fields that return a text result.
Unless you search for phrases or an exact match, 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 Hotels, Luxury.
To find text and characters:
1. Start a find request.
See Making a find request.
2. Refer to the following table for examples of different ways to search for text.
To find Type this in the field Examples
Words that start with
specific Roman 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
Japanese Hiragana,
Katakana, or Kanji
characters
The characters between =
and *
finds , , and