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
freelance developer
/

Sample input:

valueMask ( "0123456789" ; "####/##.##.##" ; "#" )

Sample output:

0123/45.67.89

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

/* ============================================
#
# Purpose:			create a masked value.
#
# Arthor:				Michael Bijnens
# Creation date:		24/02/2014
#
# Note:				recursive function
#
# Example:
#					value 		= "0123456789"
#					template 		= "####/##.##.##"
#					placeholder	= "#"
#					output		= "0123/45.67.89"
#
=============================================*/

Let (
	[
		c_placeholder	= 	PatternCount ( template ; placeholder ) ;
		end			=	c_placeholder = 0 ;
		l_temp		= 	Length ( Filter ( template ; placeholder ) ) ;
		l_value		=	Length ( value )

	] ;

		Case ( 	
				/* if replacement is complete => result 
				--------------------------------- */
				end = True ;
				template ;

				/* check if lengths are correct ( TO DO )
				------------------------- */

				/* replace each placeholder into value
				-------------------------------- */
				end = False ;
				ValueMask ( value ; Replace ( template ; Position ( template ; placeholder ; 1 ; 1 ) ; 1 ; Middle ( value ; ( l_value - c_placeholder ) + 1 ; 1 ) ) ; placeholder )

		)
)

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.

Comments

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

		Michael, Belgium Feb 25, 2014
@ Bart Bartholomay: U where right! I already changed it. Thanks..

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

ValueMask ( value ; template ; placeholder )

Comments

Support this website.

Support this website.