Newest functions Upload a function Leave a tip My account

There are 2,567 functions in this library.

format.UkTelNumber ( telNo )

A function to format phone numbers into my preferred uk format

  Average rating: 4.0 (48 votes) Log in to vote

Tim Anderson - Show more from this author Tim Anderson Group

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

/* 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 Click to copy

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

 

Comments

		chopper, east hampton Apr 3, 2009
your sample shows area calculation ,is that right?

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.

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: