I think what you have to do is to first create a List variable (of the ListC type) and then populate that list with the contents of your text file.
After you've done that, you can use ELCollections built-in functions (like ListC.Get) to retrieve the contents of that text file (which have been loaded into your list) and put them into a variable which you can analyze and manipulate.
So, I believe it would work something like this:
Code: Select all
value1 = ListC.ReadFile(vSampleList,"f:\temp\TestData\CSVData.Txt");
So, again, the collection list vSampleList, will now contain the contents of your file. Note that because you're using a ListC (a list of collections), I believe the list (vSampleList) will contain sub-lists. Consequently, when you retrieve the contents of the file, you may need to first define a second list variable (of the type ListS (string) or ListN (number)) into which the contents of the particular sub-list will be dumped. You could then cycle through each entry of the sublist to get the information you want.
For me, ELCollections can get a little confusing when it comes to lists of lists, maps of lists, etc. The documentation is pretty good in providing examples though (see page 14 specifically for some ideas). Anyway, if you can't get this to work, let me know and I will see what else I can do to help.