Generate a Random Number Of Any Length In A List

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Terry
Site Admin
Posts: 1983
Joined: Wed Sep 20, 2006 3:45 pm

Generate a Random Number Of Any Length In A List

Post by Terry » Fri Mar 29, 2013 1:40 pm

This command will generate a guaranteed Random number in a Character or Numeric Field.

Download and unzip the file linked below directly to your C:\Program Files (x86)\AccuZIP6 5.0 folder.

Import your list, and create a field that you want the number to be stored in using Edit>Fields. The field LENGTH determines the highest random number that will be generated. If the field length is 4, then the highest number could be 9999. Character fields are padded with 0, e.g., 0001

Click on Edit>Command, and run this syntax, substituting the word fieldname with your actual field name you created:

=GenRandom("fieldname")

Click Run.

You can then close the command window, and you'll see a random number filling that field, and they will all be 100% unique.

http://www.accuzip.com/files/forum/genrandom.zip

Post Reply