Replace specific letters with clearly defined numbers

DataBlendingFan

Hi All,

I am looking for a smart way to replace letters (A-Z) with clearly defined numbers (1-26) for each letter.

Lets say i have a string like "A.1.B.C" and for each letter i have a specific number (A=1, B=2, C=3) which i want to replace. Outcome should be "1.1.2.3"

Is there any smart way to avoid usage of Replace([String], "A", "1") - 26 times?

Thank you guys in advance.

Regards,

grossal

Hi @DataBlendingFan,

you could use a lookup table and the Find Replace Tool.

Input 1:

Input 2:

Find Replace Settings:

Output:

Workflow is attached. Let me know what you think.

Best

Alex

2020-05-02-Replace specific letters with clearly defined numbers.yxmd