The FileIO UDF (must be downloaded and referenced) will read a text file into an array of LINES. The CSV UDF converts a line of text in CSV format to an array, or an array to a line of text in CSV format. Download both from the Kix UDF Library on my web site.
The For/Next loop parses each record in the file data array, converting it from a CSV format to an array, and then storing the array back into the file array.
The result is an array of arrays - $aFile is an array of records in the file, $aFile[3] contains an array of fields from the CSV data that was converted.
So - if you want to examine the third field of the 12th record, you would reference $aFile[11][2] (recall that arrays are 0-based, so the first record is element 0, the third is element 2).
Glenn
_________________________
Actually I
am a Rocket Scientist!
