Search and replace records in Custom and Reference datasets
If you rename a field option in a Custom dataset or Reference dataset using individual transactions, that change won't automatically be reflected in your existing records. You would either need to update each record individually to use the new option, or you could use the Search & Replace tool to do it in bulk.
- Click on the Admin menu.
- Select Manage Datasets from the dropdown.
- Locate the dataset you want to search and click on the Search & Replace Records () button next to the dataset's name.
- Select the field you want to search from the Field to Update dropdown.
- In the Search for field, enter the text you want to find. Select the Case-sensitive search box to only retrieve results that match the exact case of the text you enter.
- In the Replace with field, enter the text that should replace the text entered in the Search for field.
- We recommend that you first click the Search button to preview how many records will be affected. This gives you a chance to modify your search before replacing any text.
- Once you are ready, click on the Replace button. This will permanently replace the values in matching records and cannot be undone, so be careful!