# 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 \$.