RE: Increment an alpha field by "1"

Just a thought:

You assign (in a table) to each letter a number (A=1, B=2,..., Z=26); after that, you perform an add like you do normally in base 10, except you use a "base" 26 (for letters)

For example: TAZ + 1, would, actually, be 20 01 26 + 01 =
(start from right to left):

26 + 01 = 27, write 01 (27 - 26), carry 1 to the left
01 + 01 = 02
20 + 00 = 20

So, the result would be 20 02 01 == TBA


Thank you


Florin Todor

Programmer/Analyst
Concord Transportation
416-679-7439



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Thursday, May 22, 2008 2:39 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Increment an alpha field by "1"

Just want to be sure that I understand the requirement.

You want to take the TAA01 portion and add 1 to it so that the next utterance is TAA02.
And that the next utterance after TAA99 is TAB00.
Right?

If so, the numeric part is easy (but you knew that). The alpha portion could probably be done, it would seem at first blush, with some bit arithmetic, but perhaps I'm being a bit naïve here. Rolling TAZxx to TBAxx could be interesting.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Vidal
Sent: Thursday, May 22, 2008 1:03 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Increment an alpha field by "1"

Hi list:

I have a field (7/A) that has a combination of letters and numbers. How will the code look so I can go from, ie.:

Original value: MTAA010
Target value: MTZZ990

The first character (M) and the last one (0) will never change. Just positions 2-6

All recommended strategies are welcome,

TIA!


PETER VIDAL
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 Tel:727-849-9999, x2414 Fax:727-815-3120 WWW.PALL.COM

"Use what talents you possess: the woods would be very silent if no birds sang there except those that sang best."
Henry Van Dyke

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication.


--------------------------------------------------------------------------------