Export and clean up Harvest invoices data

harvest-invoices.js

var data = []

$("tbody.has-clickable-table-rows tr").each(function() {

  var $t = $(this)

  var line = {
    date: $t.find(".col-issue-date").text().trim(),
    name: "#" + _cleanText($t.find(".col-id")) + "-" + _cleanText($t.find(".col-client")),
    amount: _cleanNumber($t.find(".col-amount")),
  }

  data.push(line)

});


function _cleanText(el) {
  return el.text().replace(/\s+/g, ' ').replace(",", "/").trim()
}

function _cleanNumber(el) {
  return el.text().replace(/[A-Z$ ]+/g, "")

}


function convertToCSV(objArray) {
    var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
    var str = '';

    for (var i = 0; i < array.length; i++) {
        var line = '';
        for (var index in array[i]) {
            if (line != '') line += ','

            line += array[i][index];
        }

        str += line + '\r\n';
    }

    return str;
}

// copy(str)
console.log(convertToCSV(data))