Parsing a string similar to a CSV file

Question

There is a string imitating a CSV file, you have to pass it into a function and get an array consisting of the objects. How to do it? Please help.

function STRtoArray (str) {
    // Code here
}

var str = 'Name,Age,Car,wife \n John,25,,true\n Ben,31,wolksvagen,false'

The result is expected as follows:

[
  {
    Name: John,
    Age: 25,
    Car: false,
    wife: true
  },
  {
    Name: Kolya,
    Age: 31,
    Car: wolksvagen,
    wife: false
  }
]

This question has been answered before. Take a look at : http://stackoverflow.com/questions/2858121/convert-comma-separated-string-to-array — Fio, Jan 30 '17 at 20:43
What have *you* done to try and solve this yourself? Stack Overflow isn't a code writing service. — Mike Cluck, Jan 30 '17 at 20:51

tklg · Accepted Answer · 2017-01-30T20:58:40.297

function strToArray (str) {
  var lines = str.split(/\n/);
  var keys = lines[0].split(',');
  var arr = [];
  for (var i = 1; i < lines.length; i++) {
    var line = lines[i].trim().split(',');
    var obj = {};
    for (var j = 0; j < line.length; j++) {
      obj[keys[j].trim()] = (line[j].length 
                             ? (line[j] === 'true' 
                                ? true 
                                : (line[j] === 'false'
                                  ? false
                                  : (isNaN(line[j])
                                    ? line[j]
                                    : parseInt(line[j]))))
                             : false);
    }
    arr.push(obj);
  }
  return arr;
}
var str = 'Name,Age,Car,wife \n John,25,,true\n Ben,31,wolksvagen,false'
console.log(strToArray(str));

score 0 · Answer 2 · answered Jan 30 '17 at 21:00

The solution using String.prototype.split(), Array.prototype.map() and Array.prototype.reduce()functions:

function STRtoArray(str) {
  var lines = str.split('\n'),
      keys = lines[0].trim().split(',');   // getting key fields         

  var result = lines.slice(1).map(function (l){            
    return l.trim().split(',').reduce(function (r, l, i) {
      if (i === 1) l = Number(l);  // casting 'Age' field to number type
      if (i === 3) l = Boolean(l === 'true'? 1:0);
      r[keys[i]] = l;
      return r;
    }, {});
  });

  return result;
}

var str = 'Name,Age,Car,wife \n John,25,,true\n Ben,31,wolksvagen,false'
console.log(STRtoArray(str));

Parsing a string similar to a CSV file

2 Answers2