Find and replace¶
This processor performs string replacements either in a specified column or in all columns.
Matching modes¶
By setting the replacement mode, you can specify whether you want Find/Replace to perform:
- ‘Complete value’ : replace complete cell values (For example: replace ‘average’ by ‘medium’)
- ‘Substring’ : replace all occurrences of a string within the cell. (For example: replace ‘:’ by ‘-‘)
- ‘Regular expression’: replace matches of a regular expression (with group captures, see below)
Normalization modes¶
By setting the normalization mode, you can specifiy whether you want Find/Replace to perform:
- Case-sensitive matches (‘Exact’ mode)
- Case-insensitive matches (‘Lowercase’ mode)
- Accents-insensitive matches (‘Normalize’ mode)
Note: accent-insensitive matching is only available for ‘full’ replacements
Multiple replacements¶
Find/Replace supports multiple replacements : several replacements can be applied on the same cell, one after the other. You can disable this behavior and stop after the first replacement by checking the appropriate checkbox.
Regular expressions¶
Regular expression matching supports groups captures. Groups are
referenced using the $index notation For example, if your cell contains
val-17-x
and you want to obtain V17
, you would use a replacement
from val-([0-9]*)-.*
to V$1
Notes:
- if you want to extract multiple values from a cell using a regular expression, you should use the regular expression extractor processor.
- if you want to replace by the symbol
$
, you should escape it and type\$
.