diff options
| -rwxr-xr-x[-rw-r--r--] | helper.js | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/helper.js b/helper.js index 0e1df41..e7ef5d7 100644..100755 --- a/helper.js +++ b/helper.js @@ -1,3 +1,4 @@ +#!/usr/bin/env node require("dotenv").config(); const db = require("./db"); const fs = require("fs").promises; @@ -6,8 +7,11 @@ async function main() { let studs = await fs.readFile(__dirname + "/studs.csv", "utf8"); const users = await db.query("SELECT id, username, name, surname FROM users"); for (const user of users) { - studs = studs.replaceAll(`;${user.username};`, `;${user.id};`); - studs = studs.replaceAll(`${user.username};`, `${user.name} ${user.surname};`); + let rep = `${user.username};`; + const re1 = new RegExp(";" + rep, "g"); + studs = studs.replace(re1, `;${user.id};`); + const re2 = new RegExp(rep, "g"); + studs = studs.replace(re2, `${user.name} ${user.surname};`); } await fs.writeFile(__dirname + "/studsfix.csv", studs, "utf8"); const json = await ssvToObj(studs); |