glonbh - 経済統計練習帳

function myFunction() {
 
 
var point=new Array();
  var credit=new Array();
  var number;
 
  web="https://www.boj.or.jp/statistics/boj/other/acmai/release/2017/ac170331.htm/";
 
 
   str="";
      try {
 
 var res = UrlFetchApp.fetch(web);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 
 p1=str.indexOf("<span>資産</span>");
 p2=str.indexOf("</table>",p1);
 str=str.substring(p1,p2); 
 
 
  var x=str.split("</tr>");
 
  sx=0;
  for(s=1;s<x.length;s++){
  x[s]=x[s].replace("/th","/td");
    var y=x[s].split("</td>")  
    sx=sx+1;
    credit[sx]=y[0];
    point[sx]=y[1];
  }
  number=sx-1;
 
for(s=1;s<number+1;s++){ 
 credit[s]=f(credit[s]);
 point[s]=f(point[s]);
 Logger.log(credit[s]+","+point[s]);
}
 
 
 
 
 
}
function f(str){
 
  strx=str;
  for(m=1;m<11;m++){
  strx=fresh(strx);
  }
 
  return strx;
}
 
function fresh(str){
 
  p1=str.indexOf("<");
  p2=str.indexOf(">",p1);
  sp="";
  if(p1>-1)sp=str.substring(p1,p2+1);
 
  k=str.replace(sp,"");
  return k;
}