Android Market CSV Date Conversion

Android market exports their csv files with a date format that google documents can't read. This converts the dates array to the proper format. To quickly generate the dates array, I use Notepad++ and perform a replace: Find What: \r Replace With: \r, Search Mode: Extended Replace All!

by error454

HTML

Fixed Dates:<br>
<div id="dates"></div>

JavaScript

var dates = [
    20120130,
    20120129,
    20120128,
    20120127,
    20120126,
    20120125,
    20120124,
    20120123,
    20120122,
    20120121,
    20120120,
    20120119,
    20120118,
    20120117,
    20120116,
    20120115,
    20120114,
    20120113,
    20120112,
    20120111,
    20120110,
    20120109,
    20120108,
    20120107,
    20120106,
    20120105,
    20120104,
    20120103,
    20120102,
    20120101,
    20111231,
    20111230
];

var finalString = "";
for (var i = 0; i < dates.length; i++) {
    var entry = dates[i] + "";
    var mon = entry.substr(4, 2) + "";
    var day = entry.substr(6,2) + "";
    var year = entry.substr(0, 4) + "";
    finalString += mon + "/" + day + "/" + year + "<br>"
        
    console.log( mon + "/" + day + "/" + year );
}

$("#dates").html(finalString);