increment alpha variable?

zfmejenny · 2006-10-05

I have a code variable that might be A or B or 1 or 2, etc.

I have a report that is using INCSTR(variable), but this is unable to increment the alpha variables.

Is it possible to increment to the next alpha?

Thanks!

ara3n · 2006-10-05

Here is an example on how to increment text. It will increment all the way to z.

t := 'tada';
if INCSTR(t) = '' then begin
  t[strlen(t)] := t[strlen(t)] + 1;
end else
  t := INCSTR(t);
message(t);

You can use it to do more complex code. Such as increment past z.

zfmejenny · 2006-10-06

Thanks Rashed! That worked great.

ara3n · 2006-10-06

you are welcome.

DenSter · 2006-10-06

That is a cool trick =D> it even goes beyond z

ara3n · 2006-10-06

It does go beyond z but I don't think having } as an increment makes sense.

DenSter · 2006-10-07

No that doesn't make sense indeed, but it is still a cool trick

ara3n · 2006-10-08

I usually use this trick to see if last character is a '\' when a directory is specified for files.

kriki · 2006-10-18

[Topic moved from Navision forum to Navision Tips & Tricks forum]
How wonderfull that I can sometimes move something TO the Tips & Tricks forum!

ara3n · 2008-12-31

It's sad that I have to look for my own tips and trick?

DenSter · 2008-12-31

I always do too

Jesse · 2009-01-12

tyvm for the sample and the tip!

ara3n · 2009-01-12

you are welcome.

kine · 2009-01-22

I am using this code to do the same, but with possibility to define the string of "numbers"...

IncStrAlpha(Code : Code[20]) : Code[20]
//Increment Alpha Strig
SeqText := '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'; //sequence of "numbers"
i := STRLEN(Code);
REPEAT
  Pos := STRPOS(SeqText,FORMAT(Code[i]));
  IF Pos = STRLEN(SeqText) THEN BEGIN //Is last number in row
    Code[i] := SeqText[1];      //take first number
    i := i-1;              //change number on higher position
  END ELSE BEGIN
    Code[i] := SeqText[Pos+1];
    Switched := TRUE;
  END;
UNTIL Switched or (i = 0);
EXIT(Code);

Andwian · 2010-08-10

=D> :thumbsup:

increment alpha variable?

Comments

Categories