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;
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
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]