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 - Show more from this author
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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.