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