Find and replace¶
This processor performs string replacements either in a specified column or in all columns.
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)
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
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 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
- 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