Replacement by Regular Expression
The regular expression is used to search for the set sequence of characters in each column value of the source data set. If the sequence is detected, the value is replaced with the new one. Replacement by regular expression is applied only to the data of the string type.
Note: The regular expression is a template used for search for sequences of characters. It is set using the language of rules based on a subset of regular expressions Perl (Perl regular expressions, regex).
For example:
Only digits must be used in the bank BIC. The regular expression \D: all characters that are not digits. There are О and З letters instead of digits in some BIC values. These values are replaced with Wrong BIC row.
| Source data | Values of the replacement table fields | Replacement result | |
|---|---|---|---|
| Bank BIC | Replace | Value | Replace bank BIC |
| 40147О00 | \D | Wrong BIC | Wrong BIC |
| 40147781 | 40147781 | ||
| 40155000 | 40155000 | ||
| 4017З001 | Wrong BIC | ||
The values not included into the Replacement table are processed according to the configured parameter - Replace other.