<< Click to Display Table of Contents >> Navigation: 3. Script Language > TXT. Text-File Engine > CSV-Related Commands > Get_any_Delimited_Item_from_Text |
MiniRobotLanguage (MRL)
TXT.gdat
TXT.Get_any_delimited_Item_from_Text
Use the complete TXT.-internal Buffer and extract delimited Items from there.
Here multiple Single-Character Delimiter-characters 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 somehow (not exactly) like DIC.Get_in_Order.
' Assume Line 10 Line could be AA;BB;CC;DD;EE;FF
VAN.$$LIN=10
VAR.$$DEL=;
VAR.$$IND="A","E",2
TXT.get_any_delimited_item_from_line|$$LIN|$$DEL|$$IND|$$RES
DBP.$$RES
' Result:
' BB;DD;FF
Syntax
TXT.gdat|P1|P2[|P3]
TXT.Get_any_delimited_Item_from_Text|P1|P2[|P3]
Parameter Explanation
P1 - (Input) Variable with delimiter. Delimiter can be one or multiple characters.
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