DIC.Insert

<< Click to Display Table of Contents >>

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

DIC.Insert

MiniRobotLanguage (MRL)

 

DIC.Insert

Insert Fields before specified places into a Delimited String

 

 

Intention

 

Assume you have a Line like this:

AA;BB;CC;DD;EE;FF

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

 

Now, you decide that you want to insert Columns before "A" and before "E".

 

' 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 where we want to insert new fiels before

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

 

' Now we call the command

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

 

' And Debug-Print the Result

DBP.$$RES

ENR

 

And this is the result: ;AA;BB;CC;DD;;EE;FF

 

 

 

 

 

 

 

Syntax

 

DIC.Insert|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 Insert Fields before. Technically the command will just place a delimiter in front of these fields.
           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.Insert - Sample

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

' 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 where we want to insert new fiels before

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

 

' Now we call the command

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

 

' And Debug-Print the Result

DBP.$$RES

 

' Result:

'  ;AA;BB;CC;DD;;EE;FF

ENR

 

 

 

 

Remarks

-

 

 

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.Letter_to_Number

DIC.Number_to_Letter

DIC.Remove

DIC.Set_Multiple

DIC.Set_Value

DIC.Swap