The Find Replace dialog lets you find specific data values in a table column and replace them with a different value. You cannot replace values across columns in a table. You can:
- Search for specific data values in tables.
- Replace target values with new values.
- Replace all values at the same time or incrementally one by one.
Find/Replace Values
You specify a data value to find and which value you want to replace it by completing these fields:
Option | Description |
---|---|
Find | Type the data value you want to find. The data type must be consistent with the data type of the selected column. To perform only a Find operation, click Find at the bottom of the dialog. The Find operation looks for the value in the data column in which you opened the Find/Replace dialog. |
Replace | Type a data value to replace the value in Find. The data type must be consistent with the column data type. To perform the Find/Replace operation, click Replace at the bottom of the dialog. |
Find/Replace Criteria
As an option, you can specify additional criteria for a Find/Replace operation by selecting the following check boxes:
Option | Description |
---|---|
Case Sensitive | Select to find only case-exact matches. |
Wrap Search | Select this option if you want the search to return to the top of the column after it reaches the bottom. If you do not select this option and begin your search in the middle of a column, the search only does an incremental Find for half of the column and stops. |
Actions
Select an action from these options to perform Find and Replace operations.
Option | Description |
---|---|
Find | Click to perform an incremental find of the value you entered in Find above. |
Replace | Click to replace an incremental Find value with the value you entered in Replace above. |
Replace All | Click to replace all Find values at the same time. |
Close | Click to return to the Table Data Editor. |