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?

Generate a Random Password Field in Dataset

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?

Workflow

Accepted answers

OllieClarke

@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

Password generator.yxmd

All comments

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()`?

create-password.yxmd

philipmannering

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

OllieClarke

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

Hope that helps,

Ollie

Password generator.yxmd

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.

Generate Random Passwords.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703