From: Tim Landscheidt <tim@tim-landscheidt.de>
To: pgsql-sql@postgresql.org
Subject: Re: How to split up phone numbers?
Date: Tue, 21 Feb 2012 21:40:24 +0000
Message-ID: <m3wr7f986v.fsf@passepartout.tim-landscheidt.de> (raw)
References: <4F425DB9.3060604@gmx.net>
(anonymous) wrote:
> is there a way to split up phone numbers?
> I know that's a tricky topic and it depends on the national
> phone number format.
> I'm especially interested in a solution for Germany, Swizerland and Austria.
> I've got everything in a phone number column that makes hardly sense like:
> +49432156780
> 0049 4321 5678 0
> 04321/5678-0
> and so on...
> Those 3 samples are actually the same number in different notations.
> Aim would be to get a normalized number split up in 4 seperate columns
> nr_nation
> nr_city
> nr_main
> nr_individual
> so I end up with
> 49 4321 5678 0 for central
> 49 4321 5678 42 for Mr. Smith
> Is this doable?
> It would be a start to at least split off nr_nation and nr_city.
I seem to faintly remember that there are some anomalies in
the German area codes, i. e. "+49 xy" may be city A, with
"+49 xyz" being city B. Obviously, you will also not be
able to differentiate between normal and extension numbers
if they aren't properly marked up in the input.
Tim
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: tim@tim-landscheidt.de
Subject: Re: How to split up phone numbers?
In-Reply-To: <m3wr7f986v.fsf@passepartout.tim-landscheidt.de>
* 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