CreateRandomPassword ( PasswordLength ; Parameter ; String )

Generates a random text string of a specified length from random groups of characters

Average rating: 4.8 (13 votes) Log in to vote

Bo-Anders Adamsson
Treadstone Technologies
http://www.treadstone.es

Sample input:

Case(Gmail ≠ "" ; CreateRandomPassword ( 10;11 ;"" ))

Sample output:

-e79:tkM41

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

Let(

/*
Parameter:
Defines what kind of characters are used to calculate the string.
 1 = lower case
 2 = upper case
 3 = numeric
 4 = special chars
 5 = numeric & lower case
 6 = upper case & numeric
 7 = numeric & special chars
 8 = lower & upper case
 9 = Numeric & lower & uper case
10 = lower & upper case & numeric & special chars
11 = lower x2 & upper case x2 & numeric x2 & special chars
*/

[
CharsLowerCase = "qwertzuiopasdfghjklyxcvbnm" ;
CharsUpperCase = "QWERTZUIPASDFGHJKLYXCVBNM" ;
CharsNumeric = "123456789" ;
CharsSpecial =   ",.-;:_%&$=?!" ;

CharsGroupArray = Case(
        Parameter =  1 ; CharsLowerCase ;
        Parameter =  2 ; CharsUpperCase ;
        Parameter =  3 ; CharsNumeric ;
        Parameter =  4 ; CharsSpecial ;
        Parameter =  5 ; List(CharsNumeric ; CharsLowerCase ) ;
        Parameter =  6 ; List(CharsUpperCase ; CharsNumeric) ;
        Parameter =  7 ; List(CharsNumeric ; CharsSpecial) ;
        Parameter =  8 ; List(CharsLowerCase ; CharsUpperCase) ;
        Parameter =  9 ; List(CharsNumeric ; CharsLowerCase ; CharsUpperCase) ;
        Parameter = 10 ; List(CharsLowerCase  ; CharsUpperCase ; CharsNumeric ; CharsSpecial) ;
        Parameter = 11 ; List(CharsLowerCase  ; CharsUpperCase ; CharsNumeric ; CharsLowerCase  ; CharsUpperCase ; CharsNumeric ; CharsSpecial)
) ;

CharsGroupRandomArray = Int(Random * ValueCount(CharsGroupArray)) + 1;
CharsGroup = GetValue(CharsGroupArray;CharsGroupRandomArray);
CharsCount= Length(CharsGroup) ;

Counter = PasswordLength

];

If(
Counter > 0; Let(String = String & Middle(CharsGroup; Int(Random * CharsCount) + 1; 1); String) & CreateRandomPassword(Counter - 1; Parameter; String);
String
)

)

Generates a random text string of a specified length from random groups of characters

By adding more parameters, you can adjust the probability for that group of characters being added to the password.
See parameter 11, that doubles the probability of lowercase, uppercase and numeric

This custom function is based on the one created by Martin D. Brunner, mdb

https://www.briandunning.com/cf/905

Comments

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

CreateRandomPassword ( PasswordLength ; Parameter ; String )

Comments

Support this website.

Support this website.