var dateCol = 1;
var urlColumn = 2;
var utmTermCol = 8;
var utmContentCol = 9;
var yaColumn = 10;
function HandleValues() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow();
var paddToStr = function(a){
var str = a.toString();
if(str.length == 1){
str = '0' + str;
}
return str;
var reduceByDot = function(col){
var cell = sheet.getRange(i, col).getCell(1, 1);
var str = cell.getValue();
var dotIndex = str.indexOf('.');
if(dotIndex != -1){
cell.setValue(str.substr(0, dotIndex));
for(var i = 2; i <= lastRow; i++) {
var cell = sheet.getRange(i, dateCol).getCell(1, 1);
var dateStr = cell.getValue();
var d = new Date(dateStr);
var correctedDate = paddToStr(d.getUTCDate()) + "." + paddToStr(d.getUTCMonth()+1) + "." + paddToStr(d.getUTCFullYear())
+ " " + paddToStr(d.getUTCHours()) + ":" + paddToStr(d.getUTCMinutes()) + ":" + paddToStr(d.getUTCSeconds());
Макрос 2 - обсуждение
Результат
var dateCol = 1;
var urlColumn = 2;
var utmTermCol = 8;
var utmContentCol = 9;
var yaColumn = 10;
function HandleValues() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow();
var paddToStr = function(a){
var str = a.toString();
if(str.length == 1){
str = '0' + str;
}
return str;
}
var reduceByDot = function(col){
var cell = sheet.getRange(i, col).getCell(1, 1);
var str = cell.getValue();
var dotIndex = str.indexOf('.');
if(dotIndex != -1){
cell.setValue(str.substr(0, dotIndex));
}
}
for(var i = 2; i <= lastRow; i++) {
var cell = sheet.getRange(i, dateCol).getCell(1, 1);
var dateStr = cell.getValue();
var d = new Date(dateStr);
var correctedDate = paddToStr(d.getUTCDate()) + "." + paddToStr(d.getUTCMonth()+1) + "." + paddToStr(d.getUTCFullYear())
+ " " + paddToStr(d.getUTCHours()) + ":" + paddToStr(d.getUTCMinutes()) + ":" + paddToStr(d.getUTCSeconds());