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 · Accepted solution]

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

[cplewis90]

Hey @DataBlendingFan,

Digging the name! I am also a fan of data blending! You could accomplish this with a Find/Replace Tool. I attached a workflow with an example

[DataBlendingFan]

hi @cplewis90 , @grossal  - works perfect ! THX!