torie - 経済統計練習帳

function myFunction() {
 
var ex = SpreadsheetApp.getActiveSpreadsheet(); 
var sheet =ex.getActiveSheet(); 
 
number= sheet.getLastRow();
 
var v=sheet.getRange(1,1,number,3).getValues();  
 
for(s=0;s<number;s++){
v[s][2]=v[s][2].replace("　　","")
v[s][2]=v[s][2].replace("　","");
p1=v[s][2].indexOf("：");
if(p1>0)v[s][2]=v[s][2].substring(p1+1,v[s][2].length);
}
 
 var shx = ex.getSheetByName("rev");
 
shx.getRange(1,1,number,3).setValues(v); 
 
 
 
}