p88; - 経済統計練習帳

function myFunction() {
 
  uu="http://sabajanee233.dokkoisho.com/h_tbs_mon19.html";
 
 
 
  try {
 
 var response = UrlFetchApp.fetch(uu);
 str=response.getContentText("SJIS");
 
    } 
    catch (e) {Logger.log("Fail")}
 
 
 var delta=new Array(); 
 
  var x=str.split("</tr>");
 
  tx=0;
  for(s=1;s<x.length;s++){
 
  var y=x[s].split("</td>");
  for(sx=0;sx<y.length;sx++){
 y[sx]=clean_str(y[sx]);
 y[sx]=clean_br(y[sx]);
 if(y[sx].indexOf("lt")>-1) tx=tx+1;
  if(y[sx].indexOf("lt")>-1)   delta[tx]=y[sx];
 
  }
  }
 
 
  number=tx;
  for(s=1;s<number+1;s++){
  Logger.log(delta[s]);
}
 
  var id3="1ayIzrgR2OwmkoGyA-13FLabEaKvwVLTasWfGdHCTX6E";
var ex3 = SpreadsheetApp.openById(id3);
var sh3 = ex3.getSheetByName("data");  
 
 
  var vs=new Array();
 
for(s=0;s<number+1;s++){
vs[s]=new Array();
}
 
vs[0][0]="date";
 
for(s=1;s<number+1;s++){
vs[s][0]=delta[s];
}
 
sh3.getRange(1,1,number+1,1).setValues(vs);
 
 
 
 
 
 
 
}
function clean_br(str){
 
  sp=str;
  for(kk=1;kk<25;kk++){
  sp=sp.replace("\n","△");
  }
  return sp;
}
 
 
function clean_str(str){
 
  sp=str;
  for(kk=1;kk<25;kk++){
  sp=fresh(sp);
  }
  return sp;
}
 
function fresh(strstr){
 
  strstr=""+strstr;
 
  p1=strstr.indexOf("<")
  p2=-1; 
  if(p1>-1)p2=strstr.indexOf(">",p1)
  k="";
  if(p2>-1)k=strstr.substring(p1,p2)+">";
 
  strxp=strstr.replace(k,"");
 
  return strxp;
 
}