16.00 - Finding and Replacing Data - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

You can find specific data values in a table column and replace it with a different value. You cannot replace values across columns in a table.

  1. Right-click in the column header of the column that contains the data you want to find and replace.
  2. Select Find/Replace.
  3. In Find, type the value you want to find.
  4. In Replace With, type the value you want to replace the found value with.
  5. [Optional] Under Options, select these 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.
  6. Click to select an action:
    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.
  7. Click Close to return to the Table Data Editor.