Function readFileAsCsvTable

apps/wallet/src/utils/file.utils.ts:28–72

(file: File)

};

export const readFileAsCsvTable = async (file: File): Promise<CsvTable> => {
  const reader = new FileReader();

  reader.readAsText(file);

  return new Promise((resolve, reject) => {
    reader.onload = () => {
      const csv = reader.result as string;
      const [header, ...rows] = csv.replace(/\r\n/g, '\n').split('\n');
      const headers = parseCsvLine(header);
      const table: CsvTable = {
        headers: {},
        rows: [],
      };

      for (const header of headers) {
        const headerKey = header.toLowerCase().replace(/ /g, '_');
        table.headers[headerKey] = header;
      }

      for (const row of rows) {
        const rowValues = parseCsvLine(row);
        const rowObject: CsvRow = {};

        for (let i = 0; i < headers.length; i++) {
          rowObject[headers[i]] = rowValues[i];
        }

        table.rows.push(rowObject);
      }

      // cleanup last empty row
      if (
        table.rows.length &&
        Object.values(table.rows[table.rows.length - 1]).every(value => !value)
      ) {
        table.rows.pop();
      }

      resolve(table);
    };

    reader.onerror = reject;
  });
};

const saveCsvValue = (value: string): string => {
  if (value.includes('"')) {