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

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.



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 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 20 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: