Convert Letters to Numbers 4

[Brianfree]

Hi, i have a field which has a value like...

AAFFA


I want to convert letter to a price...

A = 0
B = 1
C = 2
etc..

And have the following positions in the code...

Th H T U D

Which is Thousands, Hundreds, Tens, Units and Decimals

So if i have the following data..

AABCA
ACBCB


The price will be £12.0 & £213.50

Please can anyone help!!!

Kindest regards,

Brian

 

[GSCaupling]

Maybe the OP's moniker has a dyslexic typo, somewhere in the first 4 characters?

Nah. If that were it, I would have run into him at one of our weekly annual meetings. Of course, we had to give up our secret handshake because nobody could remember it... some members thought that was the very purpose of a "secret" handshake.

GS

[red]******^*******
[small]I[/small] [small]Love[/small] [♥] [small]Redundancy.[/small][/red]