title | tags |
---|---|
CSVToArray |
string,array,intermediate |
Converts a comma-separated values (CSV) string to a 2D array.
- Use
Array.prototype.slice()
andArray.prototype.indexOf('\n')
to remove the first row (title row) ifomitFirstRow
istrue
. - Use
String.prototype.split('\n')
to create a string for each row, thenString.prototype.split(delimiter)
to separate the values in each row. - Omit the second argument,
delimiter
, to use a default delimiter of,
. - Omit the third argument,
omitFirstRow
, to include the first row (title row) of the CSV string.
const CSVToArray = (data, delimiter = ',', omitFirstRow = false) =>
data
.slice(omitFirstRow ? data.indexOf('\n') + 1 : 0)
.split('\n')
.map(v => v.split(delimiter));
CSVToArray('a,b\nc,d'); // [['a','b'],['c','d']];
CSVToArray('a;b\nc;d', ';'); // [['a','b'],['c','d']];
CSVToArray('col1,col2\na,b\nc,d', ',', true); // [['a','b'],['c','d']];