User manual

Chapter 2 | Using databases 42
Hiding records from a found set and viewing hidden records
All records that are not in the found set are omitted, or hidden. You can omit additional records
from the found set without doing a new find.
Important Omitted records are temporarily excluded from the found set. They still exist in the
database.
Finding and replacing data
As in a word processing application, you can find and replace data across multiple fields (including
related fields) in a record or in a find request, across a found set of records or find requests, or
across text objects in a layout. You can search for data in any type of field except container fields
and fields that are not modifiable.
1. In Browse, Find, or Layout mode, choose Edit menu > Find/Replace > Find/Replace.
2. In the Find what box, type the data you want to search for. In the Replace with box, type the
replacement data.
You can’t replace data in fields that are formatted as pop-up menus, radio buttons, or checkboxes.
These fields will be counted and reported as skipped at the end of a Replace all operation.
3. Set the search options you want to use.
To Do this
Omit a specific record Display or select the record to omit, then choose Records menu > Omit.
Omit a series of records Display or select the first record in a number of consecutive records to omit, then
choose Records menu
> Omit Multiple. In the Omit Multiple dialog box, type the
number of records to omit, then click Omit.
View the omitted set Choose Records menu > Show Omitted Only.
Bring back all the records in
the file
Choose Records menu (Browse mode) or Requests menu (Find mode) > Show
All Records.
Select To
An option from the
Direction list
Choose the search direction: Forward, Backward, or All.
Match case Search for only those occurrences in which the capitalization matches the data
you specified in the Find what box.
Note In files that contain Japanese data, a find with the Match case option
cleared does not simultaneously find both the half-width and full-width version of
the same character. To comprehensively find and replace both characters, make
sure you perform separate finds for both the half-width and full-width character.
Match whole words only Search for only those occurrences that are whole words or are bounded by spaces
and/or punctuation characters.
An option in Search across In Browse mode, search across all records in the current layout or just in the
current record.
In Find mode, search across all find requests in the current layout or just in the
current find request.
Note In Layout mode, FileMaker Pro searches just in the current layout.
An option in Search within In Browse and Find modes, search within all fields in the current layout or just in
the current field.