CODEWITHSUNDEEP
javascriptjqueryparsingcsv
robinhood91
robinhood91

Reputation: 1691

Reading *.csv file using JavaScript

I have a csv file which has the following data format:

2001:200::,2001:200:ffff:ffff:ffff:ffff:ffff:ffff,
42540528726795050063891204319802818560,42540528806023212578155541913346768895,JP,,,36.0000,138.0000,,0,0

2001:208::,2001:208:ffff:ffff:ffff:ffff:ffff:ffff,
42540529360620350178005905068154421248,42540529439848512692270242661698371583,SG,,,1.3667,103.8000,,0,0

I want to only parse the item after the 1st comma (IPv6 address), and the lat/long (36.0000,138.0000 in the first record) values for this record.

How can I use JavaScript/ jQuery to do this?

Upvotes: 0

Views: 3219

Answers (4)

John Slegers
John Slegers

Reputation: 47081

Here's what you do :

$.ajax({
    type: "GET",
    url: "data.csv",
    success: function (data) {
        var data = Papa.parse(data);
        var output = {
            "IPv6" : data.data[0][1],
            "coordinates" : [data.data[1][5], data.data[1][6]]
        } /* -> These are the values you're looking for! */
    }
});

Because I can't demo the AJAX (due to cross-domain scripting issues), I'll demo just the success function below!

Demo

var data = '2001:200::,2001:200:ffff:ffff:ffff:ffff:ffff:ffff,'+ "\n" +
'42540528726795050063891204319802818560,42540528806023212578155541913346768895,JP,,,36.0000,138.0000,,0,0'+ "\n\n" +
'2001:208::,2001:208:ffff:ffff:ffff:ffff:ffff:ffff,'+ "\n" +
'42540529360620350178005905068154421248,42540529439848512692270242661698371583,SG,,,1.3667,103.8000,,0,0';

var success = function (data) {
    var data = Papa.parse(data);
    return output = {
        "IPv6" : data.data[0][1],
        "coordinates" : [data.data[1][5], data.data[1][6]]
    }
}

document.body.innerHTML = '<pre>' + JSON.stringify(success(data), null, 2) + '</pre>';
<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/4.1.2/papaparse.js"></script>

Upvotes: 0

Vector
Vector

Reputation: 747

Use the split method to turn the string into an array and then iterate thru it as you wish.

var csv = "2001:200::,2001:200:ffff:ffff:ffff:ffff:ffff:ffff,4254052872679505006389120431980\n2818560,42540528806023212578155541913346768895,JP,,,36.0000,138.0000,,0,0"; 
var myArray = csv.split("\n");//You should know what kind of new line your csv is using
myArray.map(function (e) { //Applies this function over each element of myArray that is each line of your csv
 var line = e.split(","); //Turn the comma separated string into an array
 return "The second element is: " + line[1]; //Do what you need
});

Upvotes: 3

repat
repat

Reputation: 350

Or just use CSV libraries, I'd suggest PapaParse(Browser) or BabyParse(NodeJS)

Upvotes: 0

Radmation
Radmation

Reputation: 1524

Well the same way you would in any language. First you open the file. Read it line by line. Split each line on the comma. Use the index of the array to get the value you want.

jQuery.get('file.csv', function(data) {
   alert(data); // this is a line
   var tempArray = data.split(','); // array of data
   for(var i = 0; i < tempArray.length; i++)
   {
       console.log(tempArray[i]); // probably index 1 is your IPv6 address.
   }
});

Upvotes: 2

Related Questions