-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,668
  • 5
  • 39
  • 58
bwon
  • 9
  • 4

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
  • 68,894
  • 15
  • 164
  • 232
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,138
  • 1
  • 16
  • 29