I guess that it's impossible to look for a solution which works on every existing case, specially if you're handling addresses from several countries. However, if you've certain control over the user inputs, maybe you could try replacing certain parts employing some kind of regular expression which removes numbers at the beginning/end of the string.

On 23/09/10 03:25, Andreas wrote:

Hi,

how could I divide streetnames from housenumbers ?

I have to deal with input like this:

Parkstreet 42
Parkstr. 42
Casle Avenue 42
Casle Str. 42-47
Casle Str. 54 - 55

probaply even
Casle Str. 42-47 a

Perhaps one could cut ap the 1st numeric char and regard everything left of it as the street name and the rest as house number.
OK, this would fail with "42, Parkstreet" but those aren't to frequent.

How would I do this?