csv-to-json-example

const fs = require("fs");
const csvData = fs.readFileSync("./src/data/search-results.csv", "utf8");

const [header, ...rows] = csvData.split("\n");

const keys = header.split("|");
const rowsAsArrays = rows.map((row) => row.split("|"));

const searchResults = rowsAsArrays.map((row) => {
  return {
    fields: row.map((value, i) => {
      return {
        key: keys[i],
        value,
      };
    }),
  };
});

const data = {
  searchResults: searchResults,
};

fs.writeFileSync(
  `${__dirname}\\..\\src\\data\\search-results.json`,
  JSON.stringify(data, null, 2)
);