filer.cjs

const lineByLine = require("n-readlines");
const liner = new lineByLine("WaitingList.csv");
const fs = require("fs");
const path = require("path");
const { cwd } = require("process");

let line;
let lineNumber = 0;

const fileContents = [];

while ((line = liner.next())) {
  if (lineNumber === 0 || lineNumber > 5) {
    if (line.toString().trim() !== ",") {
      if (
        line.toString().charAt(1) !== "A" &&
        line.toString().charAt(1) !== "AB"
      ) {
        const liney = line.toString();
        fileContents.push(liney);
      }
    }
  }
  lineNumber++;
}

console.log("end of file reached");
console.log(fileContents.join("\n"));

const file = path.join(cwd(), "ModifiedWaitingList.csv");
console.log(file);

fs.writeFile(file, fileContents.join("\n"), (err) => {
  if (err) {
    console.error(err);
  } else {
    console.log("Created new file successfully");
  }
});