-1

How do I take data in a json file given like this:

Ticker,Quandl Code,Name
STI,GOOG/NYSE_STI,SunTrust Banks 
AAPL,GOOG/NASDAQ_AAPL,Apple Inc

and turn it into an array like this:

var stocks = [
    ["STI,GOOG/NYSE_STI,SunTrust Banks"],
    ["AAPL,GOOG/NASDAQ_AAPL,Apple Inc"]
];
Tony Dinh
  • 6,538
  • 4
  • 38
  • 57
bwon
  • 9
  • 3

2 Answers2

4

Your input is in CSV, not JSON. The following question has a function that converts CSV for an array:

Javascript code to parse CSV data

Community
  • 1
  • 1
ColinE
  • 66,765
  • 14
  • 157
  • 225
0

you can do this :

var myarray = [];
var myJSON = "";
for (var i = 0; i < 10; i++) {

    var item = {
        "value": i,
        "label": i
    };
    myarray.push(item);
}
myJSON = JSON.stringify({myarray: myarray});

alert(myJSON);
A.A
  • 1,128
  • 1
  • 15
  • 29