Take a look at this small program...
0001 FOR I = 0 TO 625
0002 A=INT(I/26) ; B=MOD(I,26) ; C=MOD(A,26)
0003 PRINT I,CHAR(65+C),CHAR(65+B)
0004 NEXT I
It will map the numbers from 0 to 625 into AA to ZZ.
-- Rod Hills
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Here's a link to similar discussion in CDP a number of years ago. There
you'll find a couple programs and what may be a one-liner *nix solution.
http://groups-beta.google.com/group/comp.databases.pick/browse_frm/thread/c
c9509f274c79134/c40d80cdc7e46bad
(may need to be sewn together if your mail
Try this Bill. It returns a value for SUFFIX of AA1 for box 1, bag 1
and ZZ9 for box 676, bag 9. You could extend it to capture numbers also
but would need to account for the gap in the ASCII character chart
between upper case letters and numbers. This could be condensed into a
single line;
I'm throwing this together on a whim, so I hope it works right for you. You
can have as many digits as you want and decipher them
any way you need to. The key deciding how you want to encode and decode the
values.
ASCII 0-9 =
x30 to x39
48 to 57
ASCII A-Z =
x41 to x5A
65 to 90
!Build a base