Generate a Random Password Field in Dataset

[john_miller9]

Good morning all,

I'm looking to add a field in my dataset that generates a random password of 16 characters in length. The field needs to contain at least one of the following:

• lowercase letter
• uppercase letter
• number (0-9)
• special character (!@#$%^&*)

Tried searching the community and didn't see anything relevant.  Does anyone have an idea for a way to accomplish this for 15k records?

[IraWatt]

Hey @john_miller9,

Does every password need to be unique? 

[john_miller9]

Yes, that is part of the challenge!  Looking for each record to have it's unique, random password.

[PhilipMannering]

What about using `UuidCreate()`?

[PhilipMannering]

^ Aaaand that doesn't have an uppercase character....

[OllieClarke · Accepted solution]

@john_miller9 I took @PhilipMannering's workflow and put a bit more spice into his formula tool. This workflow creates 15k unique passwords, all of which contain at least 1 uppercase, lowercase, special and number.

They're not equally likely to arise, but hopefully it's good enough for your purposes

Hope that helps,

Ollie

[OllieClarke]

@john_miller9 if your list of special characters is smaller, you'll have to change the number highlighted here to the number of special characters you have -1

[john_miller9]

Thanks @PhilipMannering and @OllieClarke.  I also was going down the path of UuidCreate() function and adding in a Capital letter and special character.  Appreciate the added randomness of your solution @OllieClarke and will be able to leverage this with some minor modification for my usecase!

[Robin_McIntosh]

Here's an option using an iterative macro and ensures at least one of each criteria is met as well as no duplciated character/digit back to back.  You can control the characters/digits you'd like in the password as well as how long.  Doee not ensure uniqueness but that could be added.