PART_CODE,WH,BIN,Total
101400899611,FG,FG,155
101500899611,FG,FG,156
101600899611,FG,FG,223
1022408000,FG,FG,669
1022408001,FG,FG,427
These are the data inside my CSV files
my aim is to convert all into multidimensional array
[0][0] = PART_CODE
[0][1] = WH
[0][2] = BIN
[0][3] = Total
[1][0] = 101400899611
[1][1] = FG
[1][2] = FG
[1][3] = 155
.
.
.
My codes below
csvLoad.load("StockBalance.csv");
csvLoad.onData = function(src)
{
var array01:Array = src.split("
");
for (i=0; i<array01.length-1; i++){
var arrayPC:Array = array01*.split(",")[0];
var arrayWH:Array = array01*.split(",")[1];
var arrayBIN:Array = array01*.split(",")[2];
var arrayQTY:Array = array01*.split(",")[3];
}
// trace(array02.length);
trace("PC" + " : " + arrayPC.length);
trace("WH" + " : " + arrayWH);
trace("BIN" + " : " + arrayBIN);
trace("QTY" + " : " + arrayQTY);
}