16.10 - Find Replace - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
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.