Converting a csv file into a 2D array

[Delta]

I'm trying to convert a CSV file with 4 columns and n number of rows in to a 2D array. I see no reason why the code below doesn't work but I think I need a second opinion.

$csv = FileRead("itr-data.csv")
$csv = StringStripWS($csv, 7)
$rows = StringSplit($csv, @CRLF)

Dim $entries[$rows[0]][4]
$entries[0][0] = $rows[0]

For $i = 1 to $rows[0]
    $temp = StringSplit($rows[$i], ",", 2)
    For $j = 0 to UBound($temp) - 1
        $entries[$i][$j] = $temp[$j] ; : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:
    Next
Next

[MvGulik]

Your CSV text probably has a line that generates a case that returns more than 4 columns.

-> $entries[$rows[0]][4] ;; hardcoded limit of 4 columns for CSV data per line.

$temp = StringSplit($rows[$i], ",", 2)
;; debug.
If Not IsArray($temp) Then
    ;; output a message.
ElseIf UBound($temp, 1) > 4 Then
    ;; output a other message.
EndIf

[Delta]

Unfortunately that's not the case here. I tried your test. $temp is an array and is not greater than 4.

[Tvern]

Did you try for each row? Because when I look at this I come to the same conclusion.

Could you include the cvs file, or a cvs file with meaningless contant, that produces the error?

[MvGulik]

See next message.

(I knew there is a reason I don't like to mix indexed and none indexed array's.)

Edited September 18, 2010 by MvGulik

[UEZ]

This should work:

#include <Array.au3>
$csv = FileRead("itr-data.csv")
$csv = StringStripWS($csv, 7)
$rows = StringSplit($csv, @CRLF)
Dim $entries[$rows[0] + 1][4 + 1]
$entries[0][0] = $rows[0]
For $i = 1 to $rows[0] 
    $temp = StringSplit($rows[$i], ",", 2) 
    For $j = 0 to UBound($temp) - 1 
        $entries[$i][$j] = $temp[$j] ;
    Next
Next
_ArrayDisplay($entries)

The array dimensions were set wrongly.

Br,

UEZ

Edited September 18, 2010 by UEZ

[Realm]

When I began working with CSV files, I found that my major hangup would be that some CSV lists are formed with quotation marks wrapped to each element, which causes problems with string formating. If your csv file contains these quotation marks, I suggest doing a StringReplace to get rid of the quotation marks before spliting the string.

[Delta]

Thank UEZ that fixed it. What actually fixed it was $entries[$rows[0] + 1][4]. If I used $entries[$rows[0] + 1][4+1] I got an extra unused column which is fine but I didn't want that.