Re: HowTo divide streetname from house-nr ?

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?
>>

In response to

Browse pgsql-sql by date

  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