Brian Dunning's FileMaker Custom Functions

UKPhoneMask ( Number )

correctly format any UK telephone number

  Average rating: 4.9 (26 votes) Log in to vote

Philip McGeehan   Philip McGeehan
SMD Ltd
http://philipmcgeehan.com

Share on Facebook Share on Twitter

  Sample input:
UKPhoneMask ( 01234567890 )

UKPhoneMask ( 01134960018 )

UKPhoneMask ( 02079460018 )
  Sample output:
01234 56789

0113 496 0018

020 7946 0018

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

One space between the area code and the local number, to help distinguish the two parts clearly.
Where the local number after the code is more than six digits long, split it with a space for readability: xxx xxxx or xxxx xxxx.
There are also, exceptionally, two eight digit numbers in use which are not specifically included: 0800 1111 and 0845 4647.

 

Comments

Matt   Matt, Bournemouth
Feb 10, 2017
You are a legend

That is all
 

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.