How to change the last number into alphabet

Help Studio
1

Hi,

In an excel ,i have one column as ID
if the id have 17 digit need to update the last digit as A.
Eg:
Input: 12345678901234567
output:1234567890123456A

Thanks.

2

Hi @vaish
In the regular expression, use this \d$ to define the last digit and replace it with a letter

Check this link regex101

2 Likes
3

Hi @vaish,

string input =“12345678901234567”;
string output = input.Remove(input.Length -1,1) + “A”;

Regards,
Omkar P

1 Like
4

Hi,

Yeah its working thanks for the help.

1 Like
5

Hi,

Thanks for the Reply…

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.