Regular Expression

Use a Regular Expression (RegEx) patterns to extract or replace pieces of text.

Warning

Regular Expressions are powerful but unforgiving. You can use websites like regexr.com or regex101.com to learn more about Regular Expressions and to quickly test and debug your patterns.

Tip

In case you want to use variables in your RegEx, please escape them by adding extra % characters. Meaning, use %%variable%% instead of %variable%. This exeption is for the RegEx function only.

The pattern below removes leading zeros from a house number, meaning that Pompmolenlaan 0010 will return Pompmolenlaan 10.

Pattern: \b0*([1-9][0-9]*|0)\b

Replace: $1

Example of the Regular Expression function.