From: | Andreas Schmitz <mailinglist(at)longimanus(dot)net> |
---|---|
To: | negora <negora(at)negora(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: HowTo divide streetname from house-nr ? |
Date: | 2010-09-23 10:53:13 |
Message-ID: | 4C9B3199.8040100@longimanus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
The only chance I see is to combine the information about the
localization with the address pattern.
regards
Andreas
On 09/23/2010 09:12 AM, negora wrote:
> 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?
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Brinkman | 2010-09-23 14:13:05 | Re: Proper case function |
Previous Message | Oliveiros d'Azevedo Cristina | 2010-09-23 10:01:39 | Re: unique fields |