Parse the text data from Chase Checking or Saving activities and save as a CSV file.

chase-text2csv.js

'use strict';

const nodePath = process.argv[0],
      exePath = process.argv[1],
      inputPath = process.argv[2],
      fs = require('fs');

if (typeof inputPath === 'undefined') {
  throw new Error('Need to specify input file path.');
}

const outputPath = `${inputPath}.out.csv`;

const inputData = fs.readFileSync(inputPath, 'utf-8');

let inputDataCopy = inputData;
let parsing = null;
const regExp = /^\s*?([0-9\/]+?)  \t([^\s][^\t$]*?)\t([^\s][^\t$]*?)\t([.,\-$0-9]*?)  \t([.,\-$0-9]*?)  \t([.,\-$0-9]*?)\s*?$/m;
const resultRecords = [];
while (parsing = inputDataCopy.match(regExp)) {
  resultRecords.push([
    parsing[1], // Date
    parsing[2], // Transaction Type
    parsing[3], // Description
    parsing[4], // Debit
    parsing[5], // Credit
    parsing[6]  // Balance
  ]);
  inputDataCopy = inputDataCopy.substr(parsing[0].length);
}

const outputData = resultRecords.map((item) => item.map((value) => `"${value}"`).join(',')).join('\n');

fs.writeFileSync(outputPath, outputData, 'utf-8');

sample-data.txt

  01/01/2016  	ACH Debit	Sample Description	$123.45  	  	$987.66  
  01/01/2016  	Account Transfer	Sample Description	$123.45  	  	$1,111.11  
  01/01/2016  	ACH Credit	Sample Description	  	$1,234.56  	$1,234.56  

sample-data.txt.out.csv