How to get an array from a csv column. Js

Question

im new to js, have two question about how to parse a csv, i have a simple csv with two column, column1:'user', column2:'amount'

how can i get one array with all the 'user' column value and one array with all the 'amount' column value?
And can i loop trough the rows and use index to get the value of the two column? something like csv['amount'][0] or csv[0][1] or something like this?

ty.

what do you mean ? it's a csv with 2 column as i said column1 with users so strings with usernames and second columns with amount, with int prices. — Amnesia420, Jul 26 '21 at 09:55

score 1 · Accepted Answer · answered Jul 27 '21 at 09:53

First, declare 2 arrays, one for user, one for amount.

And then read this post to know how to read a file line by line.

After that, read this post to know how to split a string with a comma separator.

Finally, use the array.push() method to push the data into an array.

1 Answers1