Brian Dunning's FileMaker Custom Functions

PhoneFormat ( Phone ; Style )

Formatting for North American Style Numbers and Toll Free

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

Ferrell Beleshko   Ferrell Beleshko
Terra Software Corporation
http://www.terrasoftware.com

Share on Facebook Share on Twitter

  Sample input:
4032468922
403-2468922
  Sample output:
(403) 246-8922
(403) 246-8922

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

This functions formats the Phone number for you for both Regional and Toll Free Numbers. This version also contains a RED text Missing Digits message.

If you want skip all the documentation just go to the bottom of the function and you will see a clean version of the calc inside the last note.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.