<< Click to Display Table of Contents >> Navigation:  3. Script Language > String commands > !DIC.-Delimited Item Commands > DIC.Letter_to_Number

MiniRobotLanguage (MRL)

 

DIC.Letter_to_Number

Convert Description of delimited Field to numbers.

 

 

Intention

 

Assume you have a XCoordinate from A Spreadsheet like this: "AA".

  Now you want to convert it to its numeric representation which in this case would be 27.

 

 

VAR.$$LIN=AA

 

' Now we call the command

DIC.l2n|$$LIN|$$RES

 

' And Debug-Print the Result 27

DBP.$$RES

 

ENR.

 

 

 

 

Syntax

 

DIC.l2n|P1[|P2]

DIC.Letter_to_Number|P1[|P2]

 

 

Parameter Explanation

 

P1 - Field Index can be a number like 1,2,3 (makes no sense anyway) or a Letter like A, AB. Letters must not be enclosed in " ".

P2 - (optional) Variable for Result. If omitted result is placed on TOS.

 

 

 

Example

 

'***********************************

'

'***********************************

 

 

 

Remarks

This Command does somehow the same like DIC.Get_Field_Index. But unlike this command, DIC.L2N will not accept Fields in "  ".

This Command does not need Excel to be installed on the System.

 

Limitations:

-

 

 

 

See also:

 

•1.5.2 Working with Text-Strings

•VAR. - Variable Set Value/Clear

•IVS. / NVS. - If-Variable-String

•GSS. - GetSplitString

•SRT. - Sort Items

•! STR. - String Command

•GES. - Get-Extracted-String

•SBD. - String between Delimiter

•SBM. - String between Delimiter-Multiple

•FEM. - For Each Member

•LEN. - Length-of-String

•DIC.-Delimited Item Commands

•DIC.Eval_Column_List

•DIC.Format_Numeric

•DIC.Get_Field_Index

•DIC.Get_Fields

•DIC.Get_in_Order

•DIC.Insert

•DIC.Number_to_Letter

•DIC.Remove

•DIC.Set_Multiple

•DIC.Set_Value

•DIC.Swap