From: Andreas Schmitz <mailinglist@longimanus.net>
To: negora <negora@negora.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: HowTo divide streetname from house-nr ?
Date: Thu, 23 Sep 2010 12:53:13 +0200
Message-ID: <4C9B3199.8040100@longimanus.net> (raw)
In-Reply-To: <4C9AFDEC.3050601@negora.com>
References: <4C9AAC85.1000001@gmx.net>
<4C9AFDEC.3050601@negora.com>
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?
>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mailinglist@longimanus.net, negora@negora.com
Subject: Re: HowTo divide streetname from house-nr ?
In-Reply-To: <4C9B3199.8040100@longimanus.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox