Find and Replace Data | Teradata Studio/Studio Express - Finding and Replacing Data - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
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 "" .
  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.
    Replace Click to replace an incremental Find value with the value you entered in Replace.
    Replace All Click to replace all Find values at the same time.
  7. Click Close to return to the Table Data Editor.