CSVToJSON
Converts a comma-separated values (CSV) string to a 2D array of objects. The first row of the string is used as the title row.
- Use
Array.prototype.slice()
andArray.prototype.indexOf('\n')
andString.prototype.split(delimiter)
to separate the first row (title row) into values. - Use
String.prototype.split('\n')
to create a string for each row, thenArray.prototype.map()
andString.prototype.split(delimiter)
to separate the values in each row. - Use
Array.prototype.reduce()
to create an object for each row's values, with the keys parsed from the title row. - Omit the second argument,
delimiter
, to use a default delimiter of,
.
const CSVToJSON = (data, delimiter = ',') => {
const titles = data.slice(0, data.indexOf('\n')).split(delimiter);
return data
.slice(data.indexOf('\n') + 1)
.split('\n')
.map(v => {
const values = v.split(delimiter);
return titles.reduce(
(obj, title, index) => ((obj[title] = values[index]), obj),
{}
);
});
};