chTelNrTrimmen ( FonNrWieEingegeben )
Formats Swiss Telephone Numbers
Be the first to rate this function Log in to vote
Raffa Hochstrasser - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This custom function RECOGNIZES AND TRIMS SWISS TELEPHONE NUMBERS into an easy-to-read format
- Any phone number with swiss prefix will be returned formatted in 3 groups. E. g.: 079 888 77 66, 0800 88 77 66, 062 888 77 66
- Any other numbers will be returned as entered
- Any non-digit character will be removed
Create a backup-field with an exit script trigger, that stores the original number!
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.