This tool searches a character column for a specific string and replaces it with another string.
The Search and Replace tool facilitates the replacement of multiple column entries in a selected table. This tool is particularly useful when names change or specific character data changes. To search a table, the file must be open.
To use the search and replace tool:
- Open the table for which you want to search and replace data. MapInfo Pro must be able to read the tables you want to search.
- On the Tools Menu, select Search and Replace and click the Search and Replace option. The Search & Replace dialog box opens.
- Select the table and columns you want to search from the Table to Search and Column to Search drop-down lists.
- Type the text you want to find in the Search String field.
- Type the new text you want to insert into the Replacement String field.
- If the string you entered should be case sensitive, select the Case Sensitive check box.
- Click OK to begin the search and replace process.
For information about how to add a tool to the Tool Manager, see Working with MapInfo Pro Tools.