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"]
];
Your input is in CSV, not JSON. The following question has a function that converts CSV for an array:
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);
