Replacing Data

In addition to finding text, you can find and replace it. Finding and replacing text is similar to just finding it. Both tasks require you to select the cell or column you want to search in and enter a search string. However, when finding and replacing data, you can also enter a replacement string. This text is the data with which you want to replace the search string.

Find Options

You can enter up to 29 alphanumeric characters for both the search and replacement strings. Both strings also accept the Match Case and Match Whole Words Only options. However, while you can toggle the case sensitivity of the search string with the Match Case option, the replacement string is always case sensitive. This means that when replacing data, Database Manager inserts text exactly as you enter it.

You also have the option to replace the text in the current selection (a cell or column) or the current column. The Selection option button lets you replace text in the current selection. The Entire Column option button lets you replace text in the entire column.

 

See Also

How Do I...