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