desyatkov
6/1/2016 - 9:08 AM

csvParce.js

function readTextFile(file)
{
    return new Promise(function (resolve, reject) {
        var rawFile = new XMLHttpRequest();
        rawFile.open("GET", file);
        rawFile.onload = resolve;
        rawFile.onerror = reject;
        rawFile.send(null);
    });
}

readTextFile("table.csv")
    .then(function (e) {
        var text = e.target.responseText;
        var lines = text.split('\n');
        var parse = _.map(lines, function(n) {
            return e = n.split(',');
        });

        parse.forEach(function(it) {
            it.forEach(function(item, j, arr2) {
                if( !/.+(?!\.)\D+.+/.test(item) ){
                    if( !isNaN( parseFloat(item) ) ){
                     arr2[j] = parseFloat(item)
                    }
                }
            });
        });
        console.log(parse);
    }, function (e) {
        // handle errors
    });