Brian Dunning's FileMaker Custom Functions

ValueMask ( value ; template ; placeholder )

convert a value into a masked value ( by template )

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

Michael Bijnens   Michael Bijnens
freelance developer

Share on Facebook Share on Twitter

  Sample input:
valueMask ( "0123456789" ; "####/##.##.##" ; "#" )
  Sample output:

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

This custom function converts a input value into a masked value by given template.
It can be used for formatting phone numbers or variable numbering.

ATTENTION : Yet it doesn't check if the length of the input value is equal to the
length of the template! Use a Case / IF function to check.



Bart Bartholomay   Bart Bartholomay, South Florida
Feb 25, 2014
Should this string near the bottom of the CF "cf_mb_ValueMask" actually be "ValueMask"?
Michael   Michael, Belgium
Feb 25, 2014
@ Bart Bartholomay:

U where right! I already changed it.


Log in to post comments.


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

Under construction. Email me your wish list for improvements.