Home > Features > Data > Search and Replace

Search and Replace

Location: Data tab
Use Search and Replace to replace text in your data with more meaningful text. This feature is NOT case sensitive and does not have to match the entire cell's contents. 

Figure 1: Search and Replace Button and Checkbox

Click the Search and Replace button (Figure 1: item 1) to display the Search and Replace form (figure 2). 
The Enable Search and Replace checkbox (Figure 1: item 2) toggles whether this feature is active.  It allows the setting to be turned on or off without changing the actual Search and Replace configuration.

Notes:

The search is NOT case sensitive.
The search does not have to match the entire cell’s contents.
Search and replace is limited to 25 settings.

Figure 2: Search and Replace Configuration Form

#	Section	Description
1	Help	Descriptions of each field's purpose.
2	Find What	Enter the text to that will be replaced if matched. Wildcard characters can be used in this field. Wildcard Description ? matches any single character * matches zero or more characters
3	Replace With	Enter the text that will replace the text identified in the Find What field.
4	Within	A comma-separated list of fields that specify the fields that will be searched for the term. Clicking this field will display a dropdown list of available fields in the report. The list also includes an option named [SHEET]. Choosing this option will perform the Search and Replace in the entire report.
5	Save Options	Options for saving the settings defined in the form. Save - saves the options without closing the form. Save and Close - saves the options and closes the form. Close without Saving - closes the form without saving any of the settings (they are discarded).

EXAMPLE: Replace a value found in a specifc column.

Download example

EXAMPLE: Replace a value found anywhere in the dataset.

Download example

See also