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

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
ovm1576517377363.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
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.