HELP!!! How to convert CSV file into array[x][y] formation

[bauma]

PLEASE HELP!!!

Below, I have following csv data from excel:

LV, JOB, NAME, HP, SP
11, Fighter, Herran, 200, 1000
22, Warrior, Jimmy, 400, 200
12, Priest, Kim, 500, 300
33, Berserker, Lee, 1200, 100
12, Wizard, Adam, 50, 2000

I wanted to create a array like:

array[0][0]=11;
array[0][1]=Fighter;
array[0][2]=Herran;
array[0][3]=200;
array[0][4]=1000;

array[0][0]=22;
array[0][1]=Warrior;
array[0][2]=Jimmy;
array[0][3]=400;
array[0][4]=300;
.
.
.

Please kindly suggest and help.

Depend on situation, there can be extra 100 rows...

Regards,
James Ma

[mrhoo]

Make an Array by splitting the csv text on new lines,
then split each item on commas

function arrayFromCsv(csv){
    var A= csv.split('\n'), L= A.length, i= 0;
    while(i<L){
        A[i]= A[i].split(/, */);
        ++i;
    }
    return A;
}
var csvarray= arrayFromCsv(csvtext)

/*   value: Array of Arrays
    [
        ['LV', 'JOB', 'NAME', 'HP', 'SP'],
        [11, 'Fighter', 'Herran', 200, 1000],
        [22, 'Warrior', 'Jimmy', 400, 200],
        [12, 'Priest', 'Kim', 500, 300],
        [33, 'Berserker', 'Lee', 1200, 100],
        [12, 'Wizard', 'Adam', 50, 2000]
    ]