Gizmos Freeware Reviews  

Go Back   Gizmo's Freeware Forum > Freeware Forum > General Computer Support

Reply
 
Thread Tools Display Modes
Old 10. Apr 2011, 02:19 AM   #1 (permalink)
Senior Member
 
Join Date: Aug 2009
Location: Milton Keynes
Posts: 277
Default help with letters

I need something that will help me make random combinations of letters and numbers. or a text file with all possible combinations. im looking for combinations ONLY 8 digits long, only in uppercase letters A-Z 0-9 I need to see combinations as a list not a password generator that only shows 1, or is there a password generatore that I can set for 8 digits and only uppercase that will show me a list? I know this is a strange request but the brains at gizmo are the best to ask, I just dont want to sit in front of a txt file doing the combinations myself
__________________
If it ain't broke don't fix it, improve it, break it then fix it
systemcrash is offline   Reply With Quote
Old 10. Apr 2011, 02:55 AM   #2 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,833
Default

It can be done in a spreadsheet with a simple formula, for example:

Copy this into cell A1:

ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789

Copy this formula into cell B1:

=MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1)

Then copy B1 cell down the list as long as you want.

Last edited by Jojoyee; 10. Apr 2011 at 03:06 AM.
Jojo Yee is offline   Reply With Quote
Old 10. Apr 2011, 01:35 PM   #3 (permalink)
Senior Member
 
Join Date: Aug 2009
Location: Milton Keynes
Posts: 277
Default

I did think of spreadsheet but I havnt had any ecperience using it. I tried doing just uppercase letters at first A-Z I put them in A1 then I input the formula in B1 but if the = was there first it gave me error;508 if I take the = out I dont get a answer I just have the B collum full of the formula. I'l just focus on the letters for now, im using open office if it makes a difference, and will this show all the results for example start with AAAAAAAA, AAAAAAAB,AAAAAAAC, AAAAAAAD all the way to ZZZZZZZW ZZZZZZZX, ZZZZZZZY, ZZZZZZZZ? I imagine ths would be a huge text file.
__________________
If it ain't broke don't fix it, improve it, break it then fix it
systemcrash is offline   Reply With Quote
Old 10. Apr 2011, 02:41 PM   #4 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,833
Default

Error 508 is an error message for pair missing. Check if you have entered the formula correctly and make sure that RANDBETWEEN is one word without space in between. A formula must start with an equal sign, either you use a spreadsheet in OpenOffice or MSOffice.

If you enter ABCDEFGHIJKLMNOPQRSTUVWXYZ into A1, then change the formula in B1 and cells below it to the following.

=MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1) & MID($A$1,RANDBETWEEN(1,26),1)

The outcome should be something like this. Since they're random numbers, they shouldn't be sequential.

JMEHJQLY
ZVBXYIUW
LAFKGLIW
IWMOTDTQ
OIGPEUBJ
IMFHFHCR
HGVXZEMB
RXLJVJJK
SYDMIISO
ZVVOFEGA
AEPPOFXT
EQAIZBFH
....
Jojo Yee is offline   Reply With Quote
Old 10. Apr 2011, 05:14 PM   #5 (permalink)
Senior Member
 
Join Date: Aug 2009
Location: Milton Keynes
Posts: 277
Default

I got the formula right this time but it had its own problem, at the end of the formula it should have been a 8 for 8 digits as when I put 1 it only gave me 1 letter. but also its not choosing random letters its starting somewhere in the alphabet like efghijkl or mnopqrst not anything like goghujkl and it shows 3 single letters like xyz now and then or do I have to go into the few thousand rows befor I get to ones like hgyrklmj? is spreadsheet the only way to do this?
__________________
If it ain't broke don't fix it, improve it, break it then fix it
systemcrash is offline   Reply With Quote
Old 11. Apr 2011, 02:55 AM   #6 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,833
Default

Quote:
Originally Posted by systemcrash View Post
I got the formula right this time but it had its own problem, at the end of the formula it should have been a 8 for 8 digits as when I put 1 it only gave me 1 letter. but also its not choosing random letters its starting somewhere in the alphabet like efghijkl or mnopqrst not anything like goghujkl and it shows 3 single letters like xyz now and then or do I have to go into the few thousand rows befor I get to ones like hgyrklmj?
Please paste your formula here and let's see how it works.

Quote:
is spreadsheet the only way to do this?
Not the only way but it's an easy way I believe.
Jojo Yee is offline   Reply With Quote
Old 11. Apr 2011, 08:31 PM   #7 (permalink)
Senior Member
 
Join Date: Aug 2009
Location: Milton Keynes
Posts: 277
Default

I used ; in place of , because if i use comma's then i get the error508 message so my formula was =MID ($A$1;RANDBETWEEN(1;26);8)

everytime i copied the code =MID($A$1,RANDBETWEEN(1,26),1) & i got the error508 i copied and paste the code given.

I was looking into scripts that could this for me but i couldn't find the right one. Im not experienced in making scripts. There was one though that said the created txt file would be 1720GB! that's a massive amount just on a txt file if that calculation is right then i'll probably give it a miss trying to create this, I haven't got the room to store a txt file that size
__________________
If it ain't broke don't fix it, improve it, break it then fix it
systemcrash is offline   Reply With Quote
Old 11. Apr 2011, 09:29 PM   #8 (permalink)
Senior Member
 
garth's Avatar
 
Join Date: Sep 2010
Location: Here.
Posts: 1,522
Default

Quote:
Originally Posted by Jojoyee View Post
It can be done in a spreadsheet with a simple formula, for example:

Copy this into cell A1:

ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789

Copy this formula into cell B1:

=MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1) & MID($A$1,RANDBETWEEN(1,36),1)

Then copy B1 cell down the list as long as you want.
This formula is working perfectly for me in MS Excel but is producing the Error508 message in OpenOffice.
__________________
Heavy Metal + Lego = . That is all. ^.^
garth is offline   Reply With Quote
Old 11. Apr 2011, 11:32 PM   #9 (permalink)
Senior Member
 
Join Date: Aug 2009
Location: Milton Keynes
Posts: 277
Default

I'l explain what it was for, I wanted a list of combinations that could be used for a sort of key pass system for a computer login. It was to make a list of codes that could be used as a password form 8 digits long a mix of letters and numbers. I suppose it would work 6 digits long but 8 just seemed better. A complete list wouldn't have any duplicates and a name could easily be put beside the taken password in a txt or spreadsheet document. And being a complete list the user could choose there own 8 digit password that the remember and using the find feature in the documents could easily see if the password was taken. But storing a 1720GB file is not a option.

I only focused on A-Z until i got the hang of the formula or scipt creation then i would have added back in the numbers. But then i guess the file would grow further then 1720GB

I defiantly need to learn how to use spreadsheet though
__________________
If it ain't broke don't fix it, improve it, break it then fix it
systemcrash is offline   Reply With Quote
Old 12. Apr 2011, 02:44 AM   #10 (permalink)
Maestro di Search
 
Jojo Yee's Avatar
 
Join Date: Jul 2008
Posts: 7,833
Default

Quote:
Originally Posted by garth View Post
This formula is working perfectly for me in MS Excel but is producing the Error508 message in OpenOffice.
I just copied the formula over in LibreOffice and it works fine. Recheck if the formula you copied over has any spaces which split the function names. If so, you need to remove them.

Not sure if ";" has to be used to replace "," in OpenOffice as reported by Systemcrash, since now I have only LibreOffice installed on my machine.


p.s. In LibreOffice, if I change "," to ";", it automatically change back to ",". Probably this is something different between this and OpenOffice. Can anyone verify this?

Last edited by Jojoyee; 12. Apr 2011 at 02:55 AM. Reason: added: p.s.
Jojo Yee is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT +1. The time now is 11:57 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.