THAT is elegant!
Nice job, Javier!
Did you R:Style it to balance the ()s ? :)
Doug
On 5/17/2021 6:40 PM, [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] <mailto:[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
<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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8C2298%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8C2298%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<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]
<mailto:[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
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAKh6TOdvSoRDlib6RC%2Bo7akBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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/35af68a4-ebc2-bba7-1e21-be4afbd150ae%40wi.rr.com.
