<< Click to Display Table of Contents >> Navigation: 3. Script Language > TXT. Text-File Engine > CSV-Related Commands > Get_Delimited_Item_from_Text |
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:
• IEF. / NEF. - If - exist - File