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.