Skip To Content

Find and Replace

Use Find and Replace to search for data in an attribute table.

By default, the search is performed on the selected field or fields. You can make specific updates to individual values in an iterative process, or update multiple values at once. A list of the most recent entries is retained in both the Find and Replace input boxes until the project is closed. You can also specify the search method to match any, all, or just the start of the field as well as match the case. Date, GUID and numeric values are always returned using a full match. For example, searching for 10 does not return 100.

Find records in a table

The Find portion of Find and Replace scans the table for matching results. This is more efficient than manually scrolling the table and facilitates data maintenance. To find records in a table, use the following steps:

  1. Click the Table menu Menu and click Find and Replace Find and Replace to open the control in the table view.

    Alternatively, press Ctrl+F as a keyboard shortcut to open the input box.

  2. Type the value to locate in the Find input box and press Enter or click the Find button Find.

    The total number of matches is displayed near the Clear button Clear Find Results.

  3. To browse the search results, click Find Next Next or press Shift+ F3, or click Find Previous Previous or press F3. The find arrows work in a continuous loop. For example, when you click Find Previous from the result nearest the top of the table, the search continues from the bottom to find the next previous match.
  4. To select all of the matches, click Select Matches Select Matches.
  5. Perform any edits or click Close Close when you are finished to close the control without closing the table view.

Replace values in a table cell

Replacing all or part of a cell value allows you to perform repetitive updates without manual editing and improves data maintenance.

Note:

Replace is intended for small, direct changing of values such as changing Street to Road. Use the Field Calculator to perform an update that uses complex equations or references other fields.

To replace all or part of a cell value, use the following steps:

  1. Click the Table menu Menu and click Find and Replace Find and Replace to open the control in the table view.

    Alternatively, press Ctrl+F.

  2. Type the value to locate in the Find input box.
  3. In the Replace input box, type the new value to update the cell with.
  4. Press Enter or click Replace Replace to locate the first encountered instance.

    If the active cell contains the value from step 2, the replace automatically happens.

  5. Click Replace a second time to update the first encountered instance and locate the next one.

    Optionally click Replace all Replace All to update all encountered instances.

  6. Click Close Close when you are finished to close the control without closing the table view.
  7. Note:
    Your edits must be saved from the Manage Edits group on the Edit tab.

Options to refine results

Depending on the value you are trying to find, you may need to include additional criteria to improve the search results. The options, which are available in the Find drop-down menu, are as follows:

  • Match any part—Any part of the cell can match; for example, the text San returns both Pleasant and San Gabriel. This is the default behavior.
  • Match whole field—The entire cell contents must match the searched value exactly.
  • Match start of field—Only the start of the cell must match; for example, the text San returns both San Gabriel and san diego.
  • Match case—Both the phrase and capitalization must match; for example, the text San would only match San, not san.
  • Search only selected fields—Only the currently selected field or fields are searched. This is on by default.

Related topics