My problem is related to javascript and csv file. The cvs file is from a excel and is located on the server side. My final Goal is to to be able to do some statistics with these data...
I tried different methods using papaparse, csv-parser and I was getting some errors.
the following way seems to have some issue:
I used a asynch function getData() to convert it into a 2d array and it is working:
const rep=await fetch('datan2.csv')
const data=await rep.text();
let fin=[]
const table=data.split('\n').slice(1)
table.forEach(row=>{
const colums=row.split(',');
tab=[colums[0], colums[1],colums[2]]
fin.push(tab)
});
return fin
}
```
From the following code, I can easily loop the array **fin**
The problem now is when I try to get this array outside this function:
for example in the following code, where printing **t** is working but I cannot access a specific element of the array:
```t=getData()
console.log(t)//working
console.log(t[0][0])// not working here```
Can someone help? because my final goal is to be able to loop the array out side the **getData** method.
Thanks
Try replacing forEach with For..of. Like so
Replace
table.forEach(row=>{
const colums=row.split(',');
tab=[colums[0], colums[1],colums[2]]
fin.push(tab)
});
With
for(const row of table){
const colums=row.split(',');
tab=[colums[0], colums[1],colums[2]]
fin.push(tab)
}