Easy for you to say, Mr. “I can keep track of my concatenated parentheses”.
Fact is, the power of concat’d R:BASE functions never ceases to impress and amaze. Thank you! Bruce, SafeSectors. On May 17, 2021, 16:40 -0700, [email protected], wrote: > Here is the Engineer’s solution: > > SET VAR vOld TEXT = '12345C' > > SET VAR vNew = ((SGET(.vOld , ((SLEN(.vOld)) - 1) , 1 )) + > (CHAR((ICHAR((SGET(.vOld, 1, SLEN(.vOld))))) + 1))) > > That should increment the last alphanumeric character regardless of the text > variable length. > > If you want to just increment the last alphanumeric character and keep the > same variable name, you can use: > > SET VAR vOld = ((SGET(.vOld , ((SLEN(.vOld)) - 1) , 1 )) + > (CHAR((ICHAR((SGET(.vOld, 1, SLEN(.vOld))))) + 1))) > > This is as simple as it gets. > > Javier, > > Javier Valencia, PE > [email protected] > O: 913-829-0888 > C: 913-915-3137 > > > > From: [email protected] <[email protected]> On Behalf Of Dan > Goldberg > Sent: Monday, May 17, 2021 2:23 PM > To: [email protected] > Subject: [RBASE-L] - Increment letters > > 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/2E4830CEC16615458329D3D83342F8D0014E8C2298%40EXCHANGE10. > -- > 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/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAKh6TOdvSoRDlib6RC%2Bo7akBAAAAAA%3D%3D%40vtgonline.com. -- 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/9d299a16-1d42-47d9-9f87-36b68c2bfc4e%40Spark.
