Csv file to an array

Question

I have a csv file which contains the following values:

18/10/2013,  news item 1
18/10/2013,  news item 2
17/10/2013,  news item 3
16/10/2013,  news item 4

How do I go about putting this into an array in JavaScript, ordered by date?

Once I have got it into an array, I also need to get the text values.

So far I have something like this:

Function readTextFile(){

var rawFile = new XMLhttpRequest();
Var myArray;

rawFile.open("GET", csvfile, true);
rawFile.onreadystatechange = function(){

if(rawFile.readyState === 4){
  if(rawFile.Status === 200 || rawFile.Status === 0)
{

}
}
}

Sorry if the text above is not formatted properly, I am posting from my phone. thanks

possible duplicate of Javascript code to parse CSV data

Joren
– Joren

2013-10-18 10:17:32 +00:00
Commented Oct 18, 2013 at 10:17 — Joren
– Joren, Commented Oct 18, 2013 at 10:17

score 2 · Accepted Answer · 2013-10-18 14:01:26Z

2

This is how you can do it.

Function readTextFile(){

var rawFile = new XMLhttpRequest();
Var myArray;

rawFile.open("GET", csvfile, true);
rawFile.onreadystatechange = function(){

if(rawFile.readyState === 4){
  if(rawFile.Status === 200 || rawFile.Status === 0)
{
    var response = rawFile.responseText;
    var splitData = new Array();
     //split data with new line

    splitData = response.split("\n");    //stores all the values separated by new line
    console.log(splitData[0]);      //returns   18/10/2013,  news item 1

  //split single line data with comma 

    var splitComma = new Array();
    var splitComma = splitData[0].split(",");  
    console.log(splitComma[0]);          //returns  18/10/2013

   //start comparing date values here

}
}
}

edited Oct 18, 2013 at 14:01

answered Oct 18, 2013 at 10:20

user1850534

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

1 Comment

pmillio Over a year ago

Thanks this is what I needed. I appreciate your help

Anand · Accepted Answer · 2013-10-18 10:20:21Z

0

var myArray = rawFile.responseText.split(",");

But it will not sort the data according to login date

answered Oct 18, 2013 at 10:20

Anand

15k8 gold badges35 silver badges44 bronze badges

Collectives™ on Stack Overflow

Csv file to an array

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related