Return NEXT letter

[Inky Phil]

If I parse the letter 'A' out of a field is there any function or other that will tell me that the next letter alphabetically is 'B'. Parse a 'B' and the next letter is 'C' etc

Thanks in advance

Phil

[Raybaudi]

Hi,

assuming that the field that holds the letter to parse is named: "parse a letter"

the calc for the next letter is:

Let(

string = "ABCDEFGHJKILMNOPQRSTUVWXYZ";

Middle (string; Position ( string ; parse a letter ; 1 ; 1 ) + 1 ; 1 )

)

[Inky Phil]

Thanks for that Daniele

Phil