User manual

Chapter 2 | Using databases 41
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.
If you have added a tab control to a layout, when you find and replace data in Browse and Find
modes, FileMaker
Pro only finds and replaces data in the tab panel that is in front. In Layout mode,
FileMaker
Pro finds and replaces data in all tab panels.
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 click Omit in the layout bar.
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 Click Show All in the status toolbar.
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.