3. Script Language > TXT. Text-File Engine > CSV-Related Commands > Delimited_Items

TXT.dic

Previous Top Next

MiniRobotLanguage (MRL)

TXT.Delimited_Items_Insert

Insert Fields before specified places into a Delimited String, process the whole TXT.-Buffer with all lines in one run.

Intention

Technically this works like the DIC.Insert-Command.

It will however be applied to all Lines in the TXT.-Buffer.

Therefore you do not need to specify a Line, or target. Target is the complete loaded file.

This Sample is from the DIC.-Insert Command.

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

TXT.dic|P1|P2

TXT.Delimited_Items_Insert|P1|P2

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

Example

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

' DIC.Insert - Sample