Effective in version

10.1

, you can configure the options in an exception task to search and replace data values based on the data type. You can configure the options to search and replace data in any column that contains date, string, or numeric data.

When you specify a data type, the Analyst tool searches for the value that you enter in any column that uses the data type. You can find and replace any value that a string data column contains. You can perform case-sensitive searches on string data. You can search for a partial match or a complete match between the search value and the contents of a field in a string data column.