In case someone needs to organize files with different date formats yyyy-d-m vs yyyy-dd-m vs yyyy-d-mm vs yyyy-dd-mm into yyyy_mm_dd, here is the solution.
- Code: Select all
// declare
var sep = "_";
var years = "";
var days = "";
var months = "";
var rest = "";
// yyyy-dd-mm-
if (name.substring(7,8) === "_" && name.substring(10,11) === "_") {
years = name.substring(0, 4);
days = name.substring(5, 7);
months = name.substring(8, 10);
rest = name.substring(11,400);
newName= years + sep + months + sep + days + sep + rest;
}
// yyyy-d-m-
else if (name.substring(6,7) === "_" && name.substring(8,9) === "_") {
years = name.substring(0, 4);
days = name.substring(5, 6);
months = name.substring(7, 8);
rest = name.substring(9,400);
newName= years + sep + "0" + months + sep + "0" + days + sep + rest;
}
// yyyy-dd-m-
else if (name.substring(7,8) === "_") {
years = name.substring(0, 4);
days = name.substring(5, 7);
months = name.substring(8, 9);
rest = name.substring(10,400);
newName= years + sep + "0" + months + sep + days + sep + rest;
}
// yyyy-d-mm-
else if (name.substring(6,7) === "_") {
years = name.substring(0, 4);
days = name.substring(5, 6);
months = name.substring(7, 9);
rest = name.substring(10,400);
newName= years + sep + months + sep + "0" + days + sep + rest;
}