Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 23BBB1337B6B for ; Wed, 22 Sep 2010 22:25:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 17834-09 for ; Thu, 23 Sep 2010 01:25:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id A33161337B2A for ; Wed, 22 Sep 2010 22:25:04 -0300 (ADT) Received: (qmail invoked by alias); 23 Sep 2010 01:25:03 -0000 Received: from mue-88-130-16-227.dsl.tropolys.de (EHLO [192.168.0.113]) [88.130.16.227] by mail.gmx.net (mp045) with SMTP; 23 Sep 2010 03:25:03 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX180Ff0zWpY0GaGpEjwZ0MGZcmOsMUhho4pE6ILKB+ 6//f6/Wm7DFTxU Message-ID: <4C9AAC85.1000001@gmx.net> Date: Thu, 23 Sep 2010 03:25:25 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: HowTo divide streetname from house-nr ? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/80 X-Sequence-Number: 34611 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?