How to split address and extract the postal number from address?

[ppr (Peter Preuss)]

@jpwin
depending on much you can rely on the data (e.g. Variations of a Streetnumber could be 21a 15/3 etc. as well) have a look on following regex:

with resulting groups:

for working with regex and groups have a look here:
Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more