format.UkTelNumber ( )
Function stats
Average user rating
Support
FileMaker 7.0 +
Date posted
03 April 2009
Version
1
Recursive function
No
Function overview
Prototype
format.UkTelNumber (
telNo )
Parameters
telNo
Description
Formats a string on numbers/letters to UK telephone number format
Examples
Sample input
format.UkTelNumber("01234567890x123")
Sample output
01234 567890 x123
Function code
/*
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
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/214
Prototype: format.UkTelNumber( telNo )
Function Author: TimA (http://www.fmfunctions.com/mid/102)
Last updated: 03 April 2009
Version: 1
*/
// ===================================
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
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/214
Prototype: format.UkTelNumber( telNo )
Function Author: TimA (http://www.fmfunctions.com/mid/102)
Last updated: 03 April 2009
Version: 1
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
Comments
10 December 2009
Any ideas??? Thanks