mobiltlf

converting telephon numbers to Norwegian

Average rating: 4.2 (6 votes) Log in to vote

Rolf Berk
Berk Holding
http://www.berkholding.no

Sample input:

99205567
4799205567
004799205567
any other

Sample output:

99 20 55 67
+47 99 20 55 67
0047 99 20 55 67
red text as error

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( 
        [ num = Filter ( mobiltlf ;"0123456789" );
            len = Length(num) ];

Case( len = 8; TextColor(Left( num; 2) & " " & Middle( num; 3; 2) & " " & Middle( num; 5; 2) & " " & Middle( num ;7;2); RGB(0;0;0)); // uten landskode

          len = 10;  TextColor("+" & Left( num; 2) & " " & Middle( num; 3; 2) & " " & Middle( num; 5; 2) & " " & Middle( num; 7; 2) & " " & Middle( num ;9;2); RGB(0;0;0)); // med landskode med +

 len = 12;  TextColor(Left( num; 4) & " " & Middle( num; 5; 2) & " " & Middle( num; 7; 2) & " " & Middle( num; 9; 2) & " " & Middle( num ;11;2); RGB(0;0;0)); // med lands kode med 00
          TextColor(num; RGB(255;0;0) ) ) // wrong length so make text red
)

Let this function sort your telephone number

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

mobiltlf

Comments

Support this website.

Support this website.