3. Script Language > String commands > !DIC.-Delimited Item Commands > DIC.Get

MiniRobotLanguage (MRL)

DIC.Get_Fields

Get specified Fields from a Delimited String in the Original Order

Intention

Assume you have a Line like this:

AA;BB;CC;DD;EE;FF

as you can read it Line-bs-line out of a csv.-file

Now, you decide that you only need the Columns 1,2, and 5.

Note that with this command, you can specify the Columns in any order, the result will be the same.

' This is the delimiter character

VAR.$$DEL=;

' This is the Line that has delimited items

VAR.$$LIN=AA;BB;CC;DD;EE;FF

' This is the Index-List with the Elements that we want to get in the result

VAR.$$IND="A","E",2

' Now we call the command

DIC.Get|$$DEL|$$LIN|$$IND|$$RES

' And Debug-Print the Result

DBP.$$RES

' Result:

' BB;DD;FF

ENR

And this is the result: BB;DD;FF

Syntax

DIC.Get_Fields|P1|P2|P3[|P4]

Parameter Explanation

P1 - Delimiter, can be a Single character like semicolon or multiple characters like $crlf$. This is the specified delimiter that delimits the fields in the specified Line P2.

P2 - Line with delimited Items.

P3 - Variable with Index of Fields to get. Can be Single number like 1 or can be an Letter like "A". You can give a comma-separated list with Numbers of the fields to get.

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

Example

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

' DIC.Get - Sample