When you configure the find and replace options, you can select a single column by name. Or, you can configure the options to search any column that uses a date, string, or numeric data type.

When you search the task by 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, including numbers and dates. You can perform case-sensitive searches on string column 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. When you find a partial match, the Analyst tool replaces all instances of the characters that you enter in the record field.

The following table shows the result of a partial find and replace operation on a string of name data:

When you search for a date, enter the date value in the date and time stamp format that the date columns use. You can replace a null value in a date column with a date value that you specify. You cannot search for part of a date value or part of a number in a date data column or a numeric data column. You cannot perform case-sensitive searches on the contents of a date data column or a numeric data column.

You can find and replace values when you filter the task data. The find and replace operations apply to the records that meet the filter criteria. When you search on filtered data, the search operation opens the first page of task data that contains a record that meets the filter criteria.

Click

Find & Replace

to show or hide the options in the task.