FormatPhone ( PhoneIn ; AreaCode )
Masks or refomats North American phone numbers
Average rating: 4.3 (32 votes) Log in to vote
Bank of Bermuda
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Masks North American phone numbers, and adds an area code if none given. Does not reformat any numbers that don't match the North American pattern (7 or 10 digits). Used with an area code lookup table it is quite useful: FormatPhone ( PhoneNumber; Lookup ( AreaCodes::AreaCode;"")).
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.