From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: How to split up phone numbers?
Date: 23 Feb 2012 09:14:32 GMT
Message-ID: <ji501o$6ef$3@reversiblemaps.ath.cx> (raw)
References: <4F425DB9.3060604@gmx.net>
On 2012-02-20, Andreas <maps.on@gmx.net> wrote:
> Hi,
> is there a way to split up phone numbers?
several. I wouldn't trust a computer to do any of them.
> 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.
normalise them.
push them all towards the first format. the rules are relatively
simple.
now if you want to split that into parts that means something you can
probably get the gorey details from the phone company. but if you
just want do do it for display split it wherever you like.
--
⚂⚃ 100% natural
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: jasen@xnet.co.nz
Subject: Re: How to split up phone numbers?
In-Reply-To: <ji501o$6ef$3@reversiblemaps.ath.cx>
* 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