UKphoneFormat ( number )

Formats UK phone numbers with *new* 3 digits codes where required

Average rating: 4.6 (23 votes) Log in to vote

john renfrew - Show more from this author
attitude

Sample input:

UKphoneFormat ( "0207 111 0000" )
UKphoneFormat( "0207 111 0000 x123" )

Sample output:

020 7111 0000
020 7111 0000 x123

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

/*
 * convert phone numbers to *new* UK formats
 * 0207 777 1000 becomes 020 7771 0000
 * JR 21/01/2012
 * v1.0
*/

Let ( [
 _squash = TrimAll ( number ; 1 ; 3 ) ; _pre = Left ( _squash ; 3 ) ; 
 _amend = Case ( _pre = "020" ; True ; 
 _pre = "023" ; True ; _pre = "024" ; True ; _pre = "028" ; True ; _pre = "029" ; True ; False ) ; 
 _new = Left ( _squash ; 3 ) & " " & Middle ( _squash ; 4 ; 4 ) & " " & Substitute ( Middle ( _squash ; 8 ; Length ( _squash ) ) ; "x" ; " x" )
] ; 
 If ( _amend ; _new ; Trim ( number ) )
)

Formats UK phone numbers for London, Coventry etc. with 02x prefix, space, 4 digits, space, 4 digits

Comments

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

UKphoneFormat ( number )

Comments

Support this website.

Support this website.