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.

Quick Start

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:

  1. Open Data Preparation menu and click on Find and Replace.
  2. Type in Chemestry in the Find box and Chemistry in the Replace with box.
  3. Select the column Subject in the column selection pane.
  4. 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.

  1. 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.
  2. Columns: The columns on which we want to apply these results.
  3. Case Sensitive: Whether the search should be case sensitive.
  4. Entire Cell: Whether the search should match entire cell content.
  5. Condition: See Conditions in Tasks

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 & chips 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 ✔︎

See also

Conditions in Tasks

Conditions in tasks