<< Click to Display Table of Contents >> Navigation: 3. Script Language > String commands > !DIC.-Delimited Item Commands > DIC.Number_to_Letter |
MiniRobotLanguage (MRL)
DIC.Number_to_Letter
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=285
' Now we call the command
DIC.l2n|$$LIN|$$RES
' And Debug-Print the Result JY
DBP.$$RES
ENR.
Syntax
DIC.n2l|P1[|P2]
DIC.Number_to_Letter|P1[|P2]
Parameter Explanation
P1 - Field Index can be a number like 1,2,33
P2 - (optional) Variable for Result. If omitted result is placed on TOS.
Example
'***********************************
'
'***********************************
Remarks
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
•SBD. - String between Delimiter
•SBM. - String between Delimiter-Multiple