Using Find and Replace

The Find and Replace commands are available from a right-click menu in any grid column heading.

In the Find dialog, you enter a search string and direct Find to locate the string in one or more cells in the grid.
In the Replace dialog, you enter a search string and a replacement string, and direct Replace to locate and replace occurrences of the search string in the grid.

You select the Find and Replace options on the Criteria, Columns, and Selection tabs. The Selection tab is available only during a Point and Shoot session. For details on using Point and Shoot, refer to Edit Point and Shoot List.

Find/Replace dialog

To open the Find/Replace dialog, right-click a grid column heading and select Replace (or Find) from the shortcut menu.

Example of the Find and Replace dialog, described as follows.

The Find/Replace dialog displays the string from your last search or replace.

Tabs

Use the appropriate tabs to provide search Criteria and select the target Columns.

Command buttons

The following command buttons are specific to the Find/Replace dialog:

Find Next: Locate the next instance of the search string that is specified in the Find what box.
Replace: Replace the search string that is specified in the Find what box with the replacement string specified in the Replace with box.
Replace All: Replace all instances of the search string with the replacement string.

Criteria tab

Use the Criteria tab (shown in the previous example) on the Find/Replace dialog to provide search criteria. You indicate what to find and the direction of the search, and can select options for applying the criteria.

Details

Enter search criteria, supply details, and make selections as follows:

Find what: Search string. Type a value or click the down arrow to select from a list of recent search strings.
Replace with: Replacement string. Type a value or click the down arrow to select from a list of recent replacement strings.
Direction: Direction of the search from the position of the cursor in the grid. Select Up or Down and Wrap to continue until all data is searched.
Options: Instructions for applying the search string. Select Match Whole Word Only to limit the search to exact word matches and Match Case to do a case-sensitive search.

Columns tab

Use the Columns tab on the Find/Replace dialog to limit the search to selected grid columns.

The Columns tab lists all the grid columns. Select the columns that you want to target. If you are targeting most columns, click Select All and select specific grid columns for exclusion. To exclude all grid columns, click UnSelect All. Then, select individual columns to search.