Skip to content

Regular Expression

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


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


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

Regular Expression

Example of the Regular Expression function.