Re: HowTo divide streetname from house-nr ?

Поиск
Список
Период
Сортировка
От negora
Тема Re: HowTo divide streetname from house-nr ?
Дата
Msg-id 4C9AFDEC.3050601@negora.com
обсуждение исходный текст
Ответ на HowTo divide streetname from house-nr ?  (Andreas <maps.on@gmx.net>)
Ответы Re: HowTo divide streetname from house-nr ?
Список pgsql-sql
<font face="Verdana">I guess that it's impossible to look for a solution which works on every </font>existing case,
speciallyif you're handling addresses from several countries. However, if you've certain control over the user inputs,
maybeyou could try replacing certain parts employing some kind of regular expression which removes numbers at the
beginning/endof the string.<br /><br /> On 23/09/10 03:25, Andreas wrote: <blockquote
cite="mid:4C9AAC85.1000001@gmx.net"type="cite"> Hi, <br /><br /> how could I divide streetnames from housenumbers ? <br
/><br/> I have to deal with input like this: <br /><br /> Parkstreet 42 <br /> Parkstr. 42 <br /> Casle Avenue 42 <br
/>Casle Str. 42-47 <br /> Casle Str. 54 - 55 <br /><br /> probaply even <br /> Casle Str. 42-47 a <br /><br /> Perhaps
onecould cut ap the 1st numeric char and regard everything left of it as the street name and the rest as house number.
<br/> OK, this would fail with "42, Parkstreet" but those aren't to frequent. <br /><br /> How would I do this? <br
/><br/></blockquote> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Adrian Johnson
Дата:
Сообщение: unique fields
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: unique fields