German address - regular expression

Question

I have a webcall that give me the following callback as string:

ZIPCODE | CITY | STREET NR | , |Phone Number with (Tel.) on the beginning

EXAMPLE1 :

83661 Lenggries Marktstr. 14, Tel. 08042 91860

I would like to ask the regex professionals if it would be possible to break them down into groups? My best try at the moment is:

([0-9]{5})(\s[a-zA-Z].+)(\s[a-zA-Z].+)(\s.*)(\s.[0-9]*)(\s.[0-9]*)

which results in:

1. 83661
2. Lenggries
3. Marktstr. 14,
4. Tel.
5. 08042
6. 91860

This works for the sample above but is not a stable regex, for example:

EXAMPLE2:

83620 Feldkirchen-Westerham Aiblinger Str. 7, Tel. 08063 8562

results in:

1. 83620
2. Feldkirchen-Westerham Aiblinger
3. Str. 7,
4. Tel.
5. 08063
6. 8562

Maybe somebody can help me with this problem, I have no idea how to solve it. The data cannot be given in any other format either. :(

regards and thanks in advance Matthias

Answer 1

Check it in Python!

^[ \-0-9a-zA-ZäöüÄÖÜß.]+?\s+(\d+(\s?[a-zA-Z])?)\s*(?:$|\(|[A-Z]{2})\s+(\d{5})\s*(.+)

if you want to see the demo! Click here

Answer 2

Try this:

^(\d{5})\s*([a-zA-Z].+)(?=\b\d+,)(\d+).*Tel.\s([\d ]+)$

See Demo in PCRE

See C# Code Demo