Re: HowTo divide streetname from house-nr ?

Поиск
Список
Период
Сортировка
От Andreas Schmitz
Тема Re: HowTo divide streetname from house-nr ?
Дата
Msg-id 4C9B3199.8040100@longimanus.net
обсуждение исходный текст
Ответ на Re: HowTo divide streetname from house-nr ?  (negora <negora@negora.com>)
Список pgsql-sql
<br /> The only chance I see is to combine the information  about the localization with the address pattern. <br /><br
/>regards<br /><br /> Andreas<br /><br /><br /><br /><br /> On 09/23/2010 09:12 AM, negora wrote: <blockquote
cite="mid:4C9AFDEC.3050601@negora.com"type="cite"></blockquote><font face="Verdana">I guess that it's impossible to
lookfor a solution which works on every </font>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
employingsome kind of regular expression which removes numbers at the beginning/end of the string.<br /><br /> On
23/09/1003:25, Andreas wrote: <blockquote cite="mid:4C9AAC85.1000001@gmx.net" type="cite"> Hi, <br /><br /> how could I
dividestreetnames 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 one could cut ap the 1st numeric char and regard everything left of it as the
streetname 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><br /> 

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

Предыдущее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: unique fields
Следующее
От: Rob Sargent
Дата:
Сообщение: pg_config -less