Re: Incrementing An Alpha Value In CL

Hmmm...declare a character variable, len 26, and initialize with the
letters of the alphabet. Get the 8th character of the member name.
Loop through the variable with the %sst function and find that
character (dealing with end of alphabet). Add 1 to the loop counter.
Append that position's character to the end of the 7 characters.



On 8/3/07, Robert Munday <rwmunday@xxxxxxxxxxxxx> wrote:

Today's task is to increment an alpha value in a CL (A to B to C...). As some batch files process, I am to save the successfully processed file members to an archive file and assign a batch ID character on the end of each unique member name. I have a file identifer + Julian Date + AlphaSeq, which for today would be `FL07215A`. If I process a second batch today, it woud be `FL07215B`. I can capture the highest value of the eighth character in the file member name with RTVMBRD - RtvMbrD File(FILENAME) Mbr(*Last) RtnMbr(&LASTMEMBER) as the member names would be in ascending order. I could then bump the character to the next value and append it to the first seven characters of the member name.

Sure, I could write an RPG program to do this, but there must be a relatively painless way to do it within a CL. Were it my project, a numeric sequence would be the most simple to accomplish.

How to proceed?

Thanks,


Robert Munday
Munday Software Consultants
Montgomery, AL
on assignment in Nashville, TN


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.