HelpConsole 2008 SP1 - ReportsDNA Manual

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


Replace Jane with Ms Jane



in the First Name column

Original data set

ID First Name Last Name Order
1 Jane Doe Milk
2 John Doe Eggs
3 Doe Smith Milk
1 Jane Doe Butter




Search and Replace Settings
Search Field Find Replace
First Name Jane Ms Jane








Report Output

ID First Name Last Name Order
1 Ms Jane Taylor Milk
2 John Taylor Eggs
3 Taylor Smith Milk
1 Ms Jane Taylor Butter


EXAMPLE: Replace a value found anywhere in the dataset.

Download example

Replace Doe with Taylor anywhere
in the data set [SHEET]

Original data set

ID First Name Last Name Order
1 Jane Doe Milk
2 John Doe Eggs
3 Doe Smith Milk
1 Jane Doe Butter




Search and Replace Settings
Search Field Find Replace
[SHEET] Doe Taylor








Report Output

ID First Name Last Name Order
1 Jane Taylor Milk
2 John Taylor Eggs
3 Taylor Smith Milk
1 Jane Taylor Butter

See also

Advanced Filter Criteria
Duplicates
Denormalize