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;
We have a bar-code labeling challenge. We need to print hundreds of unique
serialized labels.
We have three characters available.
I am expecting to do something like
Master (pallet): H42 2x MMM H42 is our supplier ID.
Box # 1 H42 2x AA0 2x is the six-digit
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
] On Behalf Of Brutzman, Bill
Sent: Friday, April 22, 2005 11:54 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] Base 16, 26, 36
We have a bar-code labeling challenge. We need to print hundreds of
unique
serialized labels.
We have three characters available.
I am expecting to do something like