<< Click to Display Table of Contents >> Navigation: 3. Script Language > String commands > !DIC.-Delimited Item Commands > DIC.Eval_Column_List |
MiniRobotLanguage (MRL)
DIC.Eval_Column_List
Convert and sort Description of delimited Fields.
Intention
Assume you have several X-Coordinate from A Spreadsheet like this: "AA" but also like "A-C" or "3-7".
Now you want to convert it to its numeric representation which in this case would be 27.
This function will NOT remove fields that are multiple times specified.
VAR.$$LIN="1","2-5","Y-AB","J-L",21,"AC-AF","JK-JZ"
' Now we call the command
DIC.ecl|$$LIN|$$RES
' And Debug-Print the Result 27
DBP.$$RES
ENR.
' The Result
' 1,2,3,4,5,10,11,12,21,25,26,27,28,29,30,31,32,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286
Syntax
DIC.ecl|P1[|P2]
DIC.Eval_Column_List|P1[|P2]
Parameter Explanation
P1 - Field Index can be a number like 1,2,3 or a Letter like A, AB. Letters must not be enclosed in " ".
You can also specify the "-" Sign to specify a Range. Like: "A-C". This will be interpreted as "A","B","C".
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 " ".
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