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
intoV17
, use the following replacementval-([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.