farhad-taran/README.md

Created January 30, 2023 18:10

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/farhad-taran/dcf17302480908e1641e7f43f0de8aef.js"></script>
Save farhad-taran/dcf17302480908e1641e7f43f0de8aef to your computer and use it in GitHub Desktop.

Creating CSVs from arrays of objects

Raw

const makeCsv = (dataObjectsArray, fieldNamesArray) => {
  if (!dataObjectsArray || dataObjectsArray.length == 0) {
    return '';
  }
  const csvLines = []
  const formatField = field => `"${field.replace(/"/g, '""')}",`;
  csvLines.push(fieldNamesArray.map(formatField).join(''));
  dataObjectsArray.forEach(function (dataObj) {
    let line = '';
    fieldNamesArray.forEach(fieldName => {
      const fieldData = dataObj[fieldName] || '';
      line += formatField(fieldData);
    });
    csvLines.push(line);
  });
  return csvLines.join('\r\n');
};