Find and replace

Find and replace strings in one or more columns. Find/Replace supports multiple replacements: Several replacements can be applied on the same cell, one after the other.

To stop the replacement after the first occurrence, select Only perform the first matching replacement.

Options

Column

Apply find and replace to the following:

  • A single column

  • An explicit list of columns

  • All columns matching a regex pattern

  • All columns

Output column

Create a separate output column or leave blank to perform find and replace in-column.

Replacements

List the strings to match and their corresponding replacements.

Matching mode

Determine the type of replacement for find and replace to perform.

  • Complete value: replace the entire content of the matched cell

  • Substring: replace all occurrences of a string within the cell

  • Regular expression: replace matches of a regular expression

Note

  • Regular expression matching supports group captures. Reference groups using the $index notation. If you want to find/replace val-17-x into V17, use the following replacement val-([0-9]*)-.* → V$1

  • To replace the symbol $ in a regular expression match, escape it and type \$.

Normalization mode

Specify how to find the match:

  • Exact (no transformation): use case-sensitive search

  • Lowercase: use case-insenstive search

Note

Accent-insensitive normalization is only available for complete value matching.