How to store data retrieved from the server into an array with JavaScript?

Question

Can someone tell me how can I store the values of the CSV file into an array that I am retrieving from the web server.

Data example:

Time2,Price,Size
0.0,20998.0,69
0.0,20999.0,18042
0.0,21001.0,14783
0.0,21003.0,100

Suppose I have the following scenario shown below:

var url1 = 'path for CSV file'
$.get(url1, function(data) {
    // data param contains all the data that I retrieved from the csv
});

using the above example, how can I store my data into an array so the end result looks like the following:

data is a single string with all your csv content? var rows = data.split("\n") then loop through rows and split on , - but that's not all a "csv" is. You should also check for / parse for " and "". — fdomn-m
– fdomn-m, Commented Feb 24, 2021 at 17:10
I'd be surprised if nothing here can help you: stackoverflow.com/… — fdomn-m
– fdomn-m, Commented Feb 24, 2021 at 17:11

Randy Casburn · Accepted Answer · 2021-02-24 17:16:45Z

1

A very straight forward approach:

Split into lines on \n
Split each line ,

const csv = `Time2,Price,Size
0.0,20998.0,69
0.0,20999.0,18042
0.0,21001.0,14783
0.0,21003.0,100`;

const result = csv.split("\n").map(l=>l.split(','));

console.log(result);

answered Feb 24, 2021 at 17:16

Randy Casburn

14.2k1 gold badge19 silver badges32 bronze badges

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

Comments

KooiInc · Accepted Answer · 2021-02-25 08:34:39Z

0

Use a reducer (Array.reduce):

// create an array of arrays
const csvLines = `Time2,Price,Size
0.0,20998.0,69
0.0,20999.0,18042
0.0,21001.0,14783
0.0,21003.0,100`
  .split("\n")
  .map(v => v.split(","));

// bonus: to array of objects
let headers = csvLines.shift();
const fromCsv = csvLines.reduce( (acc, val) => [...acc, {
      [headers[0]]: parseFloat(val[0]),
      [headers[1]]: parseFloat(val[1]),
      [headers[2]]: parseFloat(val[2]) } ], []);
      
console.log(fromCsv);

edited Feb 25, 2021 at 8:34

answered Feb 24, 2021 at 17:11

KooiInc

124k32 gold badges145 silver badges181 bronze badges

1 Comment

Randy Casburn Over a year ago

That isn't the result to OP requested. (although it is most appropriate :-) )

Collectives™ on Stack Overflow

How to store data retrieved from the server into an array with JavaScript?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related