Phone#Format ( Phone )

Formats a 7 or 10 digit phone number

Average rating: 3.8 (45 votes) Log in to vote

Steve Bush - Show more from this author
Intellisoft Development
http://www.intellisoftdevelopment.com

Sample input:

Phone#Format ( 7025551234 )

Sample output:

702 555-1234

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

Let ( 
        [ num = Filter ( Phone ;"0123456789" );
          num = Case(Left(num;1)= "1"; Middle(num;2;20); num);  // remove 'Dial 1' if it's there
            len = Length(num) ];

Case( len = 10; TextColor(Left( num; 3) & " " & Middle( num; 4; 3) & "-" & Middle( num ;7;4); RGB(0;0;0)); // with area code
          len = 7;  TextColor( Left( num; 3) & "-" & Middle( num;4;4); RGB(0;0;0)); // without area code
          TextColor(num; RGB(255;0;0) ) ) // wrong length so make text red
)

Formats a 7 digit or 10 digit phone number. First removes a leading '1' and all alpha characters. If the result is neither 7 nor 10 digits, the phone number is displayed in red text. This function uses a space between the area code and the number, so it takes up the minimal amount of room.

Comments

		Olia, Montreal Feb 7, 2014
Thanks for this custom functions. I am new to filemaker and it helped me a lot. I have one question. How should I modify the calculation to accommodate phone numbers with area codes starting with the number 1. (ex. 108 222-2222). Thanks a lot for the help. O

		Thomas, Germany Feb 16, 2014
I believe that this phone format function is primarily for US and Canada, neither of which us 1 to start an area code. However if you comment out the 2 "num" line that should do it. // num = Case(Left(num;1)= "1"; Middle(num;2;20); num);

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

Phone#Format ( Phone )

Comments

Support this website.

Support this website.