csv-parser.js

// Simple CSV parser for browser use
class CSVParser {
    static parse(csvText) {
        const lines = csvText.split('\n').filter(line => line.trim() !== '');
        const headers = this.parseLine(lines[0]);
        const data = [];

        for (let i = 1; i < lines.length; i++) {
            const values = this.parseLine(lines[i]);
            if (values.length === headers.length) {
                const row = {};
                headers.forEach((header, index) => {
                    row[header] = values[index] || '';
                });
                data.push(row);
            }
        }

        return data;
    }

    static parseLine(line) {
        const result = [];
        let current = '';
        let inQuotes = false;
        let i = 0;

        while (i < line.length) {
            const char = line[i];
            const nextChar = line[i + 1];

            if (char === '"') {
                if (inQuotes && nextChar === '"') {
                    // Escaped quote
                    current += '"';
                    i += 2;
                } else {
                    // Toggle quote state
                    inQuotes = !inQuotes;
                    i++;
                }
            } else if (char === ',' && !inQuotes) {
                // Field separator
                result.push(current.trim());
                current = '';
                i++;
            } else {
                current += char;
                i++;
            }
        }

        // Add the last field
        result.push(current.trim());

        return result;
    }

    static stringify(data) {
        if (!data || data.length === 0) return '';

        const headers = Object.keys(data[0]);
        const csvLines = [];

        // Add header row
        csvLines.push(headers.map(header => this.escapeField(header)).join(','));

        // Add data rows
        data.forEach(row => {
            const values = headers.map(header => this.escapeField(row[header] || ''));
            csvLines.push(values.join(','));
        });

        return csvLines.join('\n');
    }

    static escapeField(field) {
        const str = String(field);
        if (str.includes(',') || str.includes('"') || str.includes('\n')) {
            return '"' + str.replace(/"/g, '""') + '"';
        }
        return str;
    }
}