Jump to content
Sign in to follow this  
Nelly

Generating A Random Password

Recommended Posts

Hi guys

On creation of a new record I need FM to generate a unique random password with the format of four numerics (0-9) and then six alpha characters (a-z). Can anyone suggest how I might go about doing this?

Seems like something so simple but cannot think where to start.

Thanks.

Share this post


Link to post
Share on other sites

Nelly,

Middle( "0123456789abcdefghjkmnpqrstuvwxyz"; (Random * 33); 1 )

will generate a single random letter/number. I dropped "i", "o", and "L" from the list since they often confused.

Share this post


Link to post
Share on other sites

Your calc is ...

Middle("0123456789"; Int(Random*10; 0)+1;1) &

Middle("0123456789"; Int(Random*10; 0)+1;1) &

Middle("0123456789"; Int(Random*10; 0)+1;1) &

Middle("0123456789"; Int(Random*10; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25; 0)+1;1)

Share this post


Link to post
Share on other sites

Excellent! Thanks so much for this. I do not understand it but it works perfectly ;-)

How does it ensure that the number will be unique? Or doesn't it?

Cheers.

Share this post


Link to post
Share on other sites

Hiya jfmcel

One thing I noticed on your fantastic calculation was that when the first random numeric was a zero it was being omitted in the field display. So I changed the first line of your script to dle("123456789"; Int(Random*9; 0)+1;1) &

This way the first generated number will never be a zero. See below.

Middle("123456789"; Round(Random*9; 0)+1;1) & Middle("0123456789"; Round(Random*10; 0)+1;1) & Middle("0123456789"; Round(Random*10; 0)+1;1) & Middle("0123456789"; Round(Random*10; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1) & Middle("qwertyuiopasdfghjkzxcvbnm"; Round(Random*25; 0)+1;1)

Share this post


Link to post
Share on other sites

Oops - I modified my calc to fix a problem introduced by using Round() and not Int(), but I screwed it up in the process. The correct answer is...

Middle("123456789"; Int(Random*9)+1;1) &

Middle("0123456789"; Int(Random*10)+1;1) &

Middle("0123456789"; Int(Random*10)+1;1) &

Middle("0123456789"; Int(Random*10)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1) &

Middle("qwertyuiopasdfghjkzxcvbnm"; Int(Random*25)+1;1)

Share this post


Link to post
Share on other sites

By definition, you cannot have both random and unique.

Once having arrived at a random number by the methods described, you need to check for uniqueness, probably with a self-join lookup. Then re-do the calc if it's not unique. I think you could do this in a calculation field but it's scotch time, not mind time so the solution is left as an exercise ......

Share this post


Link to post
Share on other sites

The chances of the password not being unique are so extremely small that it should not ever be a concern. [For this method of generating a random password, the chances of any two passwords being the same is 1/(9*10^3*25^6) or about one in 2 trillion.]

Share this post


Link to post
Share on other sites

The chance of getting a duplicate is not relevant. I recently had reason to develop some thousands of random six-digit numbers and was amazed at the frequency of duplicates. (Try throwing a simple dice and see how often you get duplicates.) Depending on how important uniqueness is, checking for duplicates could be essential.

We have a lottery here which has a jackpot based on the winning number being drawn on a second draw. The odds are, I think, 1 in 1 trillion. It has been won and there have not been anything like 1 trillion lotteries.

One of the classic problems in program development is trying to cover all those so-called 'impossible'/'never happens'/'extremely unlikely' situations. They happen on day 1 of live running.

Share this post


Link to post
Share on other sites

We are talking about passwords here. So why should duplicate passwords ever be a concern. [FM 7 Account Names would be a different story. The solution there is to let FM return an error when you try to create the account.]

Share this post


Link to post
Share on other sites

I must have been asleep when I wrote that last post.

Your calculation of the 'odds' is not correct. The apparent 'odds' are much lower than than that - 1 in zillions of trillion. However, your calculation does not generate genuine random numbers.

The chances of getting a duplicate depend on the number of records being generated.

To use some simple numbers -

a 10-sided dice

need 5 random numbers

Throw the dice 5 times and you will almost certainlky get duplicates. I can't remember the specific formula but the chance of getting two identical numbers in 5 tries is close to 1. (Ever seen the party trick of finding out how many people ina room have the same birthday? In a room of forty, you have almost certainy.)

Share this post


Link to post
Share on other sites

Thanks for the link, Shadow. I can just about remember when I knew that stuff.

Also, to jfmcel, we didn't ask for unique passwords. Nelly did.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    comment 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.