Open topic with navigation

Find and Replace

The Find and Replace controls are available in the Sheets tab (Design and Program/Simulate views only) and in the Report tab (Time Events, Macro, Patch, and Network views). Click the [Open find and replace controls] Find and Replace Icon button in the upper right corner of the view to display the Find and Replace controls.

Find and Replace Fields

Find

  1. In the Find text field, type the text for which you want to search. You can include * (asterisk) and ? (question mark) wild cards in your search criteria.
    • Use * to match part of a string. For example, "Zone*" will find all channels that include Zone in their names regardless of the text that follows Zone.
    • Use ? to match a single character. For example, "s?t" will find sit, sat, and set.
  2. Press (Enter) to find the first instance of your search text in the spreadsheet, or click the [Find previous occurrence] or [Find next occurrence] Previous and Next Icons buttons. Keyboard shortcuts for [Find next occurrence] are F3 or CTRL+G.
  3. To edit the contents of the cell, click in the cell and press (Enter) or double-click in the cell.

Replace

  1. In the Find text field, type the text that you want to find and replace.
  2. In the Replace with field, type the replacement text.
  3. Choose one of the following:
    • Click the Replace a single occurrence Replace Single Occurence Icon button to locate the first (and subsequent) occurrence of your search text and replace it with the replacement text. You can also use keyboard shortcut CTRL+H.
    • Click the [Find previous occurrence] or [Find next occurrence] Previous and Next Icons buttons to locate an instance of the search text that you want to replace, and click the Replace a single occurrence Replace Single Occurence Icon button to replace the text. Keyboard shortcuts for [Find next occurrence] are F3 or CTRL+G.