Thx it looks like I need to get up to par on char ☺️ Dan Goldberg MIS Manager Lance Campers
________________________________ From: [email protected] <[email protected]> on behalf of A. Razzak Memon <[email protected]> Sent: Monday, May 17, 2021 12:48:20 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Increment letters Dan, Here's how ... You can use the ICHAR function to capture the ASCII integer value, increment by 1, then use the CHAR function to return the letter value. (ICHAR(arg)) Converts a single character, returning its corresponding ASCII integer value. In the following example, the integer value of vichar is 65. SET VAR vIChar = (ICHAR('A')) (CHAR(integer)) Converts an ASCII integer value to its corresponding character. This is not the same as the CHAR data type. In the following example, the value of vchar1 is A and the value of vchar2 is a. SET VAR vChar1 = (CHAR(65)) SET VAR vChar2 = (CHAR(97)) Have fun! Very Best R:egards, Razzak. At 03:22 PM 5/17/2021, Dan Goldberg wrote: >I have a number with a letter suffix. > >12345C > >I need to increment it to the next letter. So it would be: > >12345D > >Has anyone done this before? I am drawing a blank… > >TIA > >Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0MclnD-1m0XDw2ALJ-00Hwlr%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SJ0PR17MB44473CFE4EBB78E632384BDAAA2D9%40SJ0PR17MB4447.namprd17.prod.outlook.com.
