Replace last letter with the corrsponding alphabet number

Hi, I am trying to replace the letter of the Invoice number to the corresponding alphabet number.

For example,

From INV000980A to INV0009801

From 2020809AC to 2020809A3

Please take note that the invoice number can be any form of combination, but it will end with a letter from A to Z, I wish to change to the corresponding numeric number.

Thank you.

Preparation

Accepted answers

fmvizcaino

Hi @Haokun ,

Here is a solution for you.

Best,

Fernando Vizcaino

2020-08-19 Replace last letter with the corrsponding alphabet number.yxmd

All comments

fmvizcaino

Hi @Haokun ,

Here is a solution for you.

Best,

Fernando Vizcaino

2020-08-19 Replace last letter with the corrsponding alphabet number.yxmd

bhrmitra

Hi Haokun,

Please refer to the screenshot below.

Solution - Abhra Mitra.png

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Replace last letter with the corrsponding alphabet number - Abhra Mitra.yxmd

grazitti_sapna

Hi @Haokun , here is the solution to your problem.

Thanks.

Replace last character.yxmd

paulfound

Hi Haokun,

You could use a formula like this:

REGEX_Replace([From], "\w$", tostring(CharToInt(right([From],1))-64))

Use regex to find the last letter of the invoice "\w$"
CharToInt turns the letter into ascii and the code for A = 65, B=66
Remove 64 so that you get 1 for A, etc
if it can be lower case these numbers would change, so you would need to upper case the letter before conversion.

Haokun

Thanks so much for the Regex, I will test out later.

Haokun

Thank you!! that totally works

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703