Finding and Replacing Data - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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 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.