HowTo divide streetname from house-nr ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: HowTo divide streetname from house-nr ?
Date: 2010-09-23 01:25:25
Message-ID: 4C9AAC85.1000001@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2010-09-23 02:08:31 Re: HowTo divide streetname from house-nr ?
Previous Message Rob Sargent 2010-09-22 19:51:09 pg_config -less