Exception Management Guide

10.5.4
- 10.5.5
- 10.5
- 10.4.0

Back Next

Replacing a Single Value in Exception Records

Find and replace a data value in a column that you specify or in any date, string, or numeric column. Use the filters to find and replace the value in a subset of the records in the task.

Open the exception task.

On the

Data Editing

tab, click

Edit

Click

Find & Replace

The Analyst tool shows the find and replace options above the list of records.

Enter a data value in the

Find

field.

Specify a column to search. Or, specify a data type.

If you select a data type, the Analyst tool searches the columns that use the data type. By default, the Analyst tool searches for the data value in all string data columns.

If you search for a data value in a string data column, select or clear the following options:

Case sensitive. Perform a case-sensitive search on the string data.

Match whole field. Search for a match between the value that you enter and the complete contents of a field in a record.

You cannot perform case-sensitive searches or partial data searches on columns of date data or numeric data.

Click

Find

The Analyst tool highlights the first record that contains the value that you specify. Use the arrows to move through the records.

Optionally, enter a value in the

Replace with

field.

To replace the highlighted value with the value that you entered, click

Replace

Repeat the step to find and replace additional instances of the value in the task.

Rename Saved Search

Table of Contents

Exception Management Guide

Exception Management Guide

Replacing a Single Value in Exception Records

Replacing a Single Value in Exception Records