find and replace
Feature Description
The Find and Replace function in the attribute table is used to find records in the currently opened attribute table that meet the search criteria and supports replacing the found content with specified values. Through the Find and Replace function, you can quickly locate and modify data in the attribute table without manual editing, thereby improving data maintenance efficiency.
Two methods are provided: Search Content and Search criteria, where only Search Content supports replacing the found content. Search criteria offers two modes: semi-automatic SQL statement input and manual SQL input.
Function Entry
- Table tab -> Browse group -> Find and replace.
- In the tabular, use the shortcut Ctrl+F.
- Tabular context menu -> Find and replace.
Operation Steps
- In the tabular, use the shortcut Ctrl+F to open the Find and Replace dialog;
- Select the search method, which provides two ways: Search Content and Search criteria. The default search method is Search Content.
- Search Content: Enter the content to find in the text input box, then click the find button. The drop-down button records the last five search histories; you can quickly select a search history via the drop-down button to perform the search.
- Fuzzy search: Used to set whether to perform fuzzy search, with the default being fuzzy search. Selecting this option indicates fuzzy search; not selecting it is an accurate query, meaning that the cell content must exactly match the search value to be found.
- Replace with: Enter the new value to replace in the input box. Two methods are provided: Replace and Replace all. Click the Replace button to replace only the single selected record; if no record is selected, it will start replacing from the first found result, and consecutive clicks will sequentially replace downward through the search results. Click the Replace all button to replace all found results at once.
- Search criteria: By default, it is semi-automatic SQL input; you can switch to manual SQL input mode by checking SQL Input. For issues related to SQL Expression input, refer to SQL Query Building Way. Both modes provide Import, Export, Clear, and function features:
- Import: Import a file (xml) that contains SQL Expressions to improve work efficiency;
- Export: Export the currently written SQL Expression to an xml file for reuse in querying the attribute table with the same expression;
- Clear: When the expression content is extensive, use the clear button to quickly remove expression information;
- Function: The function button provides function help, allowing you to quickly view function information and usage methods through function search, and automatically add functions to the SQL Expression input box by double-clicking in the function list.
- Search Content: Enter the content to find in the text input box, then click the find button. The drop-down button records the last five search histories; you can quickly select a search history via the drop-down button to perform the search.
- Set the conditional statement in the semi-automatic SQL input box. Select a field in the field selection box, choose a logical operator in the operation box, then the unique values of that field will be provided as options in the drop-down button of the right-side text box; select the desired item to find.
- Use the Add clause button, choose And or Or logical expressions to query the attribute table with multiple conditional statements as search criteria; set the statement expressions as in step 3;
- After adding the statements, click the Find button, and the search results will be displayed below the dialog, with qualified records highlighted in the attribute table. Above the search result list, previous/next buttons are provided for switching between search results.
Figure: Search Content Figure: Search Criteria
Related Topics