FileMaker Pro Custom Functions

/* Name: format.UkTelNumber History: Created by Tim Anderson, Tim Anderson Group www.timanderson.co.uk Creation Date: 3 April 2009 Purpose: A function to format numbers into my preferred uk format. Could easily be tweaked to add brackets or any text. Parameters: telNo Example: format.UkTelNumber("01234567890") returns 01234 567890 format.UkTelNumber("01234567890x123") returns 01234 567890 x123 Requires Other Custom Functions: None Other Notes: 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 Options: None */ Let([ //------------------------- VARIABLES _number=Substitute(telNo;" ";""); _second=Middle ( _number ; 2 ; 1 ); _fourth=Middle ( _number ; 4 ; 1 ); _length=Length(_number); _partA=Case(_second=7;5;_second="1" and _fourth="1";4;_second="8";4;_second="2";3;_second="3";3;5); _partB=Case(_partA = "3" or _partA="4";3;Min(_length-_partA;6)); _partC= 11-_partA-_PartB; _extension=_length-11 ]; //------------------------- RESULT Left(_number;_partA) & " " &Middle ( _number;_partA+1; _partB) & " " & Middle ( _number;_partA+_partB+1;_partC)& " " & Middle ( _number;_partA+_partB+_partC+1; _extension) ) // End Let
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.