CSV to JSON in angularjs

Question

I am trying to convert CSV to JSON in angularjs, but I am unable to.

Here is the raw data, I receive from API -

"sentby: Sanjay, sitename: Flipkart, PinCode: 080, stdnumber: 56477382, website: https://flipkart.com, status: Done".

I want to convert this to JSON

@ManishMallavarapu yes I am splitting the string now, but later I realized that ng-model won't work, I am using comma delimiter — Sanjay Achar
– Sanjay Achar, Commented May 20, 2016 at 16:39
let res = {};str.split(', ').forEach(s=>{let t = s.split(': '); res[t[0]] = t[1];}); — vp_arth
– vp_arth, Commented May 20, 2016 at 16:45

rob · Accepted Answer · 2016-05-20 16:46:23Z

4

You could convert a csv string into an object with something like this

var csv = "sentby: Sanjay, sitename: Flipkart, PinCode: 080, stdnumber: 56477382, website: https://flipkart.com, status: Done";
console.log(csv
    .split(',')
    .reduce(function (obj, field) {
        var parts = field.split(':');
        obj[parts[0].trim()] = parts[1].trim();
        return obj;
    }, {}));

answered May 20, 2016 at 16:46

rob

18.7k13 gold badges73 silver badges95 bronze badges

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

2 Comments

Amy Blankenship Over a year ago

This answer could probably be improved by explaining why it works. Not everyone understands how reduce and similar methods of the Array object work.

maurice Over a year ago

This works for the given example, but not all CSVs. The allowance for escaped commas makes it trickier.

Collectives™ on Stack Overflow

CSV to JSON in angularjs

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related