Brian Dunning's FileMaker Custom Functions

randomLetterString ( n ; string ; numOp )

Random string generator. You select length and whether or not to include numbers. Also, the random string may be added to a preset string to form the desired length.

  Average rating: 4.3 (38 votes) Log in to vote

Bill Holt   Bill Holt
Notesoft
www.notesoft.com

Share on Facebook Share on Twitter

  Sample input:
randomLetterString ( 8 ; "" ; 0 )

or

randomLetterString ( 12 ; "FRONTEND" ; 1 )
  Sample output:
anuuzhnb


or


FRONTEND28bl

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

This string generator (a Custom Function in FM & or later) creates a result that is as random as the Filemaker Random function allows. It is recursive. That is, it selects the first character of the string, recalls itself to select and append the second character, and repeats the process until the desired length is achieved. If you enter a "1" as the third parameter, the digits - 0 to 9 - will be included in addition to the letters a to z.

rev: slight randomness flaw corrected, sprelling cheeker used.

You can make a 500 character random string as easily as a four character one. It's pretty quick - less than a second on a G4 Mac Mini for the 500 character string.

I've incorporated this into a process for generating passwords that are keyed to the name of the registrant, the name of the organization, and another check sum, which creates a ridiculously hard to break, checkable, random result.

Enjoy.

billholt@iglou.com

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.