I have some addresses.csv in this formats
Street 1 Street 10 Street 100 Street 1000 Straße 1b Straße1b Street 1 B Street, 1B The Street 1B The-Street 1B The'Street 1B The&Street 1B The Str. 1B Street 1-3 Street 1 - 3 Street 1A-3B Street 1A -3 B Super's Street-Str., 1 - 1000B
Is there a way to seperate/extract all street names and street numbers?
Street Street Street Street Straße Straße Street Street The Street The-Street The'Street The&Street The Str. Street Street Street Street Super's Street-Str.
1 10 100 1000 1b 1b 1 B 1B 1B 1B 1B 1B 1B 1-3 1 - 3 1A-3B 1A -3 B 1 - 1000B
I have found a solution that I want to share here:
match()as I show in my answer if you like and you think that regexp you wrote is adequate for the set of addresses you want to match.