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