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.
