Does anyone know of a way to serially increment text?

For example, if a field contains the value of "A", incrementing it would result in "B". A value of "B" would increment to "C", etc.

I haven't found any built-in text functions to handle this, and would like to avoid having a table to store replacement values.

What increments the field: script, another field?

What happens when you reach 'Z', start over at 'A'?

It would increment via script. It is not expected that it would need to increment beyond "Z".

Since I needed to get something done pretty quickly, I ended up using a related table to store replacement values. IE: the original table only stores a number, but the related table has an alpha value for each number. Not the most elegant solution, but it works.

I'd still ike to know if there's a way to increment text via script, though.

Use a serial number field like normal and a calculation for the "Serail Text"

MySerialText = Middle ("ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; MySerialNUMBER;1)

That does the trick. Thanks!

and you could get away from the use of a serial field if you use the position() function to find where your current letter is in the string of letters then just get the letter from the next position.

Don

"It is not expected that it would need to increment beyond "Z"."

Famous last words.

I'd be working out now what to do when this condition eventuates.

"It is not expected that it would need to increment beyond "Z"."

Famous last words.

I'd be working out now what to do when this condition eventuates.

http://fmforums.com/forum/showpost.php?post/244248/

Base 26 conversion would be the ultimate solution! Yes.