PhoneFormat ( Phone )

(A simplified version of phone.format)

Average rating: 4.1 (14 votes) Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

PhoneFormat(1234567)
PhoneFormat(1234567890)
PhoneFormat(11234567890)
PhoneFormat(1234)
PhoneFormat(1-2-3-4x5c6h7)
PhoneFormat(1-2-3-4x5c6h7890)

Sample output:

123-4567
(123) 456-7890
1 (123) 456-7890
1234
123-4567
(123) 456-7890

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

Let(NewNumber=Filter ( Phone ; "0123456789" );
Case ( 
        not IsEmpty ( NewNumber ) ;
            Case (Length(NewNumber)=10;
                    "(" & Left(NewNumber;3) & ") " & Middle(NewNumber; 4;3) & "-" & Right(NewNumber;4);

                      Length(NewNumber) = 7;
                      Left(NewNumber; 3) & "-" & Right(NewNumber;4);

                     Length(NewNumber) = 11;
 //                    Left(NewNumber;1)& " (" &Middle ( NewNumber;2;3)& ") " & Middle(NewNumber; 5;3) & "-" & Right(NewNumber;4)  //Keep 1 at beginning
                       "(" &Middle ( NewNumber;2;3)& ") " & Middle(NewNumber; 5;3) & "-" & Right(NewNumber;4)                                     //Remove 1
    ;NewNumber)
))

I designed this so that you wouldn't have to worry about entering in any 'format' variable since that seemed kind of redundant and unnecessary. Figured I would share it just in case anyone else felt the same way and just wanted a simpler function to work with.

Comments

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

PhoneFormat ( Phone )

Comments

Support this website.

Support this website.