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

TXT.gdit

Previous Top Next

MiniRobotLanguage (MRL)

TXT.gdit

TXT.Get_delimited_Item_from_Text
Use the complete TXT.-internal Buffer and extract delimited Items from there.
Here a multicharacter delimiter can be specified.

Intention

This Command is useful if you have to do with csv-files.

This Command can be used to work on a "Line by line" base through a file working with delimited Items.

The Command will extract single delimited Items but can also be used to extract multiple Items in one run.

The Items will be returned in their normal order, no Matter in which order the Items are specified.

Internally this Command works like DIC.Get_in_Order .

' Assume the Textbuffer contains:"AA;BB;CC;DD;EE;FF"

VAN.$$LIN=10

VAR.$$DEL=;

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

TXT.get_delimited_item_from_text|$$LIN|$$DEL|$$IND|$$RES

DBP.$$RES

' Result:

' BB;DD;FF

Syntax

TXT.gdit|P1|P2[|P3]

TXT.Get_delimited_Item_from_Text|P1|P2[|P3]

Parameter Explanation

P1 - (Input) Variable with delimiter

P2 - (Input) Variable with Index of item to get. Can also be a List of Items to get. The List can contain whether the Column-Number or the Letter in "".
The Items will be returned in their normal order, no Matter in which order the Items are specified.

1,3,"C","AA"

P3 - (Output) Variable for Result

Example

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

Remarks

Limitations:

See also:

• TXT.Load Textfile

• TXT.Clear

• TXT.From_Var

• TXT.Load_pure_Text

• TXT.Get_pure_Text