Brian Dunning's FileMaker Custom Functions

format.UkTelNumber ( telNo )

A function to format phone numbers into my preferred uk format

  Average rating: 4.0 (48 votes) Log in to vote

Tim Anderson   Tim Anderson
Tim Anderson Group

Share on Facebook Share on Twitter

  Sample input:
format.UkTelNumber("01234567890")
  Sample output:
01234 567890

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

If you are inputting numbers directly use quotes, otherwise the initial 0 will be dropped. When referencing fields make sure they are defined as text.
Definition of _partA can be tweaked as new number formats are released/discovered

 

Comments

chopper   chopper, east hampton
Apr 3, 2009
your sample shows area calculation ,is that right?
 

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.