Generate a Random Password Field in Dataset
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @john_miller9,
Does every password need to be unique?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, that is part of the challenge! Looking for each record to have it's unique, random password.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
^ Aaaand that doesn't have an uppercase character....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
