Find and Replace
The Find and Replace task allows replacing of values in text columns with another text value. This can be done conditionally.
When to use
- When you want to replace text in one more columns.
- When you want to apply a find and replace conditionally.
- When you want to partially replace a text value found in some of the columns.
Quickstart
Let us start with the following sample data.
| Name | Subject |
|---|---|
| Alice | Physics |
| Bob | Chemestry |
| Chuck | Mathematics |
| Diana | Biology |
By observing the data, we see that the word Chemestry is misspelled. Let us assume we would like to correct the spelling. To achieve that,complete the following steps:
- Go to Transform > Label, Filter and Replace.
- Select the Find and Replace function.
- Type in Chemestry in the Find box and Chemistry in the Replace with box.
- Select the column Subject in the column selection pane.
- Click APPLY.
Data will look as shown below:
| Name | Subject |
|---|---|
| Alice | Physics |
| Bob | Chemistry |
| Chuck | Mathematics |
| Diana | Biology |
Supported Options
The following options are supported.
- Find and Replace pairs: The value to find and the value to replace with. More than one pair can be used here. Blank values are valid replace values.
- Columns: The columns on which we want to apply these results.
- Case Sensitive: Whether the search should be case sensitive.
- Entire Cell: Whether the search should match entire cell content.
- Condition: See Condition.
Search Modes
This section describe the functioning of case sensitive and entire cell options.
Case sensitive
This option treats uppercase and lowercase spellings separately. Refer the following table for examples:
| Search Value | Actual Text in Data | Match |
|---|---|---|
| fish | fish & chips | ✔︎ |
| Fish | fish & chips | ✘ |
Entire cell
This option determines whether the search is limited to only entire cells or partial content of cells.
If it is set to entire cell mode, the matching works as shown below:
| Search Value | Actual Text in Data | Match |
|---|---|---|
| fish | catfish | ✘ |
| Fish | fish & chips | ✔︎ |
If the option is not set, the matching works as shown below:
| Search Value | Actual Text in Data | Match |
|---|---|---|
| fish | catfish | ✔︎ |
| fish & chips | fish & chips | ✔︎ |