Finding and Replacing Data - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.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 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.