parse \r strings from CSV file

Question

I am reading a csv file in javascript by first spliting by newline then spiliting by comma. I am able to parse the whole of csv successfully but only one thing is left. i.e. the last one

I don't know how to remove those \r . The code I am using is

    function csvJSON(csv){
        var lines=csv.split("\n");
        var result = [];
        var headers=lines[0].split(",");
        for(var i=1;i<lines.length;i++){
            var obj = {};
            var currentline=lines[i].split(",");
            for(var j=0;j<headers.length;j++){
                  obj[headers[j]] = currentline[j];
            }
            result.push(obj);
         }
         return result; //JavaScript object
     }

var lines=csv.split(/\r?\n/); try this

Akhilesh Singh
– Akhilesh Singh

2016-04-13 04:04:54 +00:00
Commented Apr 13, 2016 at 4:04 — Akhilesh Singh
– Akhilesh Singh, Commented Apr 13, 2016 at 4:04

Nick Rassadin · Accepted Answer · 2016-04-13 04:01:42Z

8

By standard CSV lines are ended with CRLF ('\r\n'). But if you expect to support non-stardard line endings also test for others as well:

var lines=csv.split(/\r\n|\n|\r/);

answered Apr 13, 2016 at 4:01

Nick Rassadin

9007 silver badges7 bronze badges

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

Comments

Joundill · Accepted Answer · 2020-12-04 00:34:27Z

0

Use trim() to remove \r

obj[headers[j].trim()] = currentline[j].trim();

edited Dec 4, 2020 at 0:34

Joundill

7,84113 gold badges40 silver badges54 bronze badges

answered Dec 3, 2020 at 16:53

asaruteen

1

Comments

Satish Kumar sonker · Accepted Answer · 2016-04-13 04:04:47Z

-1

Try below code

var data='{"batting_score":"52","wickets":"0","runs_conceded":"12","catches":"0","stumps":"0","opposition":"v Pakistan","ground":"Dhaka","date":"18-Mar-12","match_result":"won","result_margin":"6 wickets","toss":"lost","batting_innings":"2nd"}'.replace(/\r/g,'');
var JsonData=JSON.parse(data);

now you can access properties like below

JsonData.batting_score //52

answered Apr 13, 2016 at 4:04

Satish Kumar sonker

1,3089 silver badges16 bronze badges

Collectives™ on Stack Overflow

parse \r strings from CSV file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related