PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

Check if a given password complies with the rules you set

Average rating: 4.4 (26 votes) Log in to vote

Martin D. Brunner
none
http://none.com

Sample input:

PasswordChecker ( "Guggus+,1" ; 1 ; 1 ; 1 ; 1 ; 8 )

PasswordChecker ( "Gug+,1" ; 1 ; 1 ; 1 ; 1 ; 8 )

Sample output:

1

0

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

/*

PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

This function checks if a given password complies with the rules you set for passwords to be used in your solution.

Parameters:
Password 		Text	Password you want to check
UpperCaseLetters 		Number	How many Upper Case Letters are required in the password?
LowerCaseLetters 		Number	How many Lower Case Letters are reuqired in the password?
Numbers			Number	How many Numbers are required in the Password?
SpecialCharacters 		Number	How many Special Characters are required in the password?
MinLength 		Number	How long must the password be in minimum

The result given back is a boolean: 1: comply, 0: doesn't comply

------------------------------------------------------------------------ */


Let ([

UpperCaseCheck	= Case ( Length ( Filter ( Password ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" )) ≥ UpperCaseLetters ; 1 ; 0 ) ;
LowerCaseCheck	= Case ( Length ( Filter ( Password ; "abcdefghijklmnopqrstuvwxyz" )) ≥ LowerCaseLetters ; 1 ; 0 ) ;
NumCheck	= Case ( Length ( Filter ( Password ; "0123456789" )) ≥ Numbers ; 1 ; 0 ) ;
SpecialCheck	= Case ( Length ( Filter ( Password ; ",;.:-_$£!§+@#°"  ) ) ≥ Numbers ; 1 ; 0 ) ;
MinLengthCheck	= Case ( Length ( Password )  ≥ MinLength ; 1 ; 0 ) ;
Check		= UpperCaseCheck + LowerCaseCheck + NumCheck + SpecialCheck + MinLengthCheck

];

Case ( Check = 5 ; 1 ; 0 )

)

PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

This function checks if a given password complies with the rules you set for passwords to be used in your solution.

Parameters:
Password Text Password you want to check
UpperCaseLetters Number How many Upper Case Letters are required in the password?
LowerCaseLetters Number How many Lower Case Letters are reuqired in the password?
Numbers Number How many Numbers are required in the Password?
SpecialCharacters Number How many Special Characters are required in the password?
MinLength Number How long must the password be in minimum

The result given back is a boolean: 1: comply, 0: doesn't comply

Comments

		Jeep Watson, Baltimore Mar 13, 2015
Your SpecialCheck has a wrong reference: â‰¥ Numbers ; 1 ; 0 ) should be â‰¥ SpecialCharacters ; 1 ; 0 )

		Martin Mar 13, 2015
Correct - sorry, my bad and thanks for letting me know!

		Andy Hibbs, Norfolk, UK Jan 7, 2016
We did have a problem that was resolved by adding GetAsNumber () around MinLength when passing variables to the parameters. To be safe we added this to all the parameters within the Let and it has worked well since.

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

PasswordChecker ( Password ; UpperCaseLetters ; LowerCaseLetters ; Numbers ; SpecialCharacters ; MinLength )

Comments

Support this website.

Support this website.