UKPhoneMask ( Number )

correctly format any UK telephone number

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

Philip McGeehan - Show more from this author
SMD Ltd
http://philipmcgeehan.com

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)

/*	Created by Philip McGeehan 27/01/2014
	Purpose: To correctly format any UK telephone number;
	separating the area code from the local number for clarity.
	Telephone number format information from  http://www.area-codes.org.uk/formatting.php
*/

Let ( 	digits = Filter ( Number ; "0123456789" ) ;

	Case ( 

// 01 and 02 Geographic Phone Numbers

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "013873" ;				// 013873 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "015242" ;				// 015242 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "015394" ;				// 015394 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "015395" ;				// 015395 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "015396" ;				// 015396 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "016973" ;				// 016973 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "016974" ;				// 016974 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 10 and Left ( digits ; 6 ) = "016977" ;				// 016977 ####
			Left ( digits ; 6 ) & " " & Right ( digits ; 4 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "016977" ;				// 016977 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "017683" ;				// 017683 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "017684" ;				// 017684 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "017687" ;				// 017687 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 6 ) = "019467" ;				// 019467 #####
			Left ( digits ; 6 ) & " " & Right ( digits ; 5 );

		Length ( digits ) = 11 and Left ( digits ; 3 ) = "011" ;				// 011# ### ####
			Left ( digits ; 4 ) & " " & Middle ( digits ; 5 ; 3 ) & " " & Right ( digits ; 4 );

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "01" and Middle ( digits ; 4 ; 1 ) = "1" ;	// 01#1 ### ####
			Left ( digits ; 4 ) & " " & Middle ( digits ; 5 ; 3 ) & " " & Right ( digits ; 4 );

		Length ( digits ) = 10 and Left ( digits ; 2 ) = "01" ;				// 01### #####
			Left ( digits ; 5 ) & " " & Right ( digits ; 5 ) ;

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "01" ;				// 01### ######
			Left ( digits ; 5 ) & " " & Right ( digits ; 6 ) ;

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "02" ;				// 02# #### ####
			Left ( digits ; 3 ) & " " & Middle ( digits ; 4 ; 4 ) & " " & Right ( digits ; 4 );

// 03 UK Wide Numbers

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "03" ;				// 03## ### ####
			Left ( digits ; 4 ) & " " & Middle ( digits ; 5 ; 3 ) & " " & Right ( digits ; 4 );

// 05 Business and VOIP numbers

		Length ( digits ) = 10 and Left ( digits ; 4 ) = "0500" ;				// 0500 ######
			Left ( digits ; 4 ) & " " & Right ( digits ; 6 );

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "05" ;				// 05### ######
			Left ( digits ; 5 ) & " " & Right ( digits ; 6 );

// 07 Mobiles and Personal numbers

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "07" ;				// 07### ######
			Left ( digits ; 5 ) & " " & Right ( digits ; 6 );

// 08 Special Rate Numbers

		Length ( digits ) = 10 and Left ( digits ; 2 ) = "08" ;				// 08## ######
			Left ( digits ; 4 ) & " " & Right ( digits ; 6 );

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "08" ;				// 08## ### ####
			Left ( digits ; 4 ) & " " & Middle ( digits ; 5 ; 3 ) & " " & Right ( digits ; 4 );

// 09 Premium Rate Numbers

		Length ( digits ) = 11 and Left ( digits ; 2 ) = "09" ;				// 09## ### ####
			Left ( digits ; 4 ) & " " & Middle ( digits ; 5 ; 3 ) & " " & Right ( digits ; 4 );

		Number									// NO MATCH RESULT (leave as entered)

	) // END CASE
) //END LET

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, Bournemouth Feb 10, 2017
You are a legend That is all

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

UKPhoneMask ( Number )

Comments

Support this website.

Support this website.