Fairly simple, actually... it will require reading the manual and building upon the examples for directory enumeration (DIR command) and using the For/Each construct. A basic understanding of arrays is also required.
Locate the following UDFs: FileIO, CSV, XLLib (optional)
Place the content of these UDFs in your script - DO NOT modify them.
FileIO loads an entire file into an array, making it easy to search or enumerate.
CSV translates between CSV format and a Kix array (and back)
xlLib is a library of ready to use Excel interface functions.. a bit advanced for step 1
Use the DIR command to enumerate the files in the folder.
For Each file, load it into an array using the FileIO function
$aFileData = FileIO($Filename, 'R')
Use a For Each loop to enumerate the array. Pass each array element (which is a CSV string) to the CSV function
For Each $DataLine in $aFileData
$aTemp = CSV($DataLine)
$aTemp now contains an array created from the CSV format data. If you need columns 3 and 6 from the CSV record, that would be array elements 2 and 5. Add these to an output array.
$aOut = $aTemp[2], $aTemp[5] ; temporary array holding desired CSV columns
If you use the xlLib Excel library, you can write this array directly to an Excel file.
If you instead want to create an output CSV file to load into Excel (easier, but extra manual step), write the output to a CSV file using the CSV function to convert the array back to CSV format:
$Rc = RedirectOutput('output.csv')
CSV($aOut) @CRLF
$Rc = RedirectOutput('')
End the for loop, then close the directory enumeration loop.
There's a lot to do, so start by writing the loop to enumerate the CSV files in the directory and just print their names. When that works, call the FileIO and then print the first element of the array (first line of the file). When that works, proceed to the next step of converting the CSV line to an array and display the fields you want..
If you approach this step by step, it won't be too difficult.
Glenn
_________________________
Actually I
am a Rocket Scientist!
