I have a list of addresses, with both street name and number together. I would like to keep only the street name.
The issue is that the number can be both in the beginning (e.g. 8, Rue du Matelas) and at the end (e.g. Kerkstraat 7).

If possible I would also like to exclude the letters when having for example different appartments in one house: (e.g. Schulstrasse 7b)

Thanks in advance!