Brian Dunning's FileMaker Custom Functions

Phone Format

(A simplified version of phone.format)

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

Kyle Williams   Kyle Williams
Sphere Solar Energy
Spheresolarenergy.com

Share on Facebook Share on Twitter

  Sample input:
Phone Format(1234567)
Phone Format(1234567890)
Phone Format(11234567890)
Phone Format(1234)
Phone Format(1-2-3-4x5c6h7)
Phone Format(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)

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

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.