Convert letter to muber

[Renderer]

Hello there ! Is there any posibility to convert a letter into a number? For example A into 1.

Thanks in advance

[Melba23]

Renderer,

Perhaps Asc() will do what you want?

M23

[JLogan3o13]

Or, if you're looking for a 1-26 conversion, something like this perhaps:

$abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
    MsgBox(0, "", convert(9))

Func convert($n)
    return StringMid($abc, $n, 1)
EndFunc

 

[water]

If you need to translate Excel column letters to numbers (or vice versa) then there is a function available in the Excel UDF.

[mikell]

Wasn't it letter into a number ?

$abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
    MsgBox(0, "", convert("I") )

Func convert($n)
    return StringInStr($abc, $n)
EndFunc

 

[Renderer]

Sorry for the mistake in the title ! I meant 'number' !

[Trong]

Like this?
 

ConsoleWrite("FA = " & _HexToDecimal("Fa") & @CRLF)
MsgBox(0, "Str2Num", "FA = " & _HexToDecimal("Fa"))

Func _HexToDecimal($HxD, $xSN = 1)
    $HxD = StringStripWS($HxD, 8)
    If StringLeft($HxD, 2) = "0x" Then $HxD = StringMid($HxD, 3)
    If StringIsXDigit($HxD) = 0 Then
        If $xSN = 1 Then Return Number($HxD)
        Return SetError(1, 0, "")
    EndIf
    Local $x, $HxD_TMP, $xOutput, $HxD_Count = 0, $HxD_Array = StringSplit($HxD, "")
    For $x = $HxD_Array[0] To 1 Step -1
        $HxD_TMP = StringInStr("0123456789ABCDEF", $HxD_Array[$x]) - 1
        $xOutput += $HxD_TMP * 16 ^ $HxD_Count
        $HxD_Count += 1
    Next
    Return $xOutput
EndFunc   ;==>_HexToDecimal

 

[jguinch]

strange way 

MsgBox(0, "", convert("A"))

Func convert($n)
    Return StringRegExp($n, "(?i)^[a-z]$") ? Number(StringToBinary (StringLower($n))) - 96 : 0
EndFunc

 

MsgBox(0, "", convert("b"))

Func convert($n)
    Return StringRegExp($n, "(?i)^[a-z]$") ? Asc($n) - 96 : 0
EndFunc

 

Edited June 2, 2016 by jguinch

[MilesAhead]

4 hours ago, Renderer said:

Sorry for the mistake in the title ! I meant 'number' !

Well you know what they say about computers.  Mubers in, mubers out.

 

[JLogan3o13]

And @Trong wins the Rube Goldberg machine award yet again...