我只想删除多余的逗号，但不想移动任何数据。只要去掉多余的逗号，让单元格为空。
| 一种|B| c型|d| e的|关闭|
| - -----|- -----|- -----|- -----|- -----|- -----|
| 第一排|1| 0|、|、|、|
| 第二排|1| 1| 3|、|、|
| 第三排|1|、|3|、|、|
我想要=
| 一种|B| c型|d| e的|关闭|
| - -----|- -----|- -----|- -----|- -----|- -----|
| 第一排|1| 0||||
| 第二排|1| 1| 3|||
| 第三排|1||3|||
我写了下面的代码，多余的逗号被删除，但数据被转移到前一列：

const fs = require('fs');
const readline = require('readline');

// Function to remove extra commas from a line
function removeExtraCommas(line) {
    let withinQuotes = false;
    let result = '';

    for (let i = 0; i < line.length; i++) {
        const char = line[i];

        if (char === '"') {
            withinQuotes = !withinQuotes;
            result += char;
        } else if (char === ',' && withinQuotes) {
            result += char;
        } else if (char === ',' && !withinQuotes) {
            const nextChar = line[i + 1];

            if (nextChar === ',') {
                result += '';
            } else {
                result += char;
            }
        } else {
            result += char;
        }
    }

    return result;
}

// Function to process the CSV file
function processCSVFile(filePath) {
    const outputFilePath = '../70_primary_codesData2CSV/70 Primary Codes Data/19120/19120(828+828_new)withoutExtraS.csv';
    const fileStream = fs.createReadStream(filePath);
    const rl = readline.createInterface({
        input: fileStream,
        crlfDelay: Infinity
    });

    const outputStream = fs.createWriteStream(outputFilePath);

    rl.on('line', (line) => {
        const processedLine = removeExtraCommas(line);
        outputStream.write(processedLine + '\n');
    });

    rl.on('close', () => {
        console.log('CSV file processed successfully.');
    });
}

// Example usage
const filePath = '../70_primary_codesData2CSV/70 Primary Codes Data/19120/19120(828+828_new).csv'; // Replace with your input file path
processCSVFile(filePath);