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
– Amnesia420, Commented Jul 26, 2021 at 9:55

The KNVB · Accepted Answer · 2021-07-27 09:53:07Z

1

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.

answered Jul 27, 2021 at 9:53

The KNVB

3,8523 gold badges35 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1