おｊｋ - 経済統計練習帳

var univ=new Array();
var dep=new Array();
var point=new Array();
 
function myFunction() {
 
  ex2 = SpreadsheetApp.openById("1a6qJV1IQ2kGsiOuSmWTDBfkMEMDSOHx60G9MQhpEDm4");
 sh2 = ex2.getSheetByName("b");
 
number=sh2.getLastRow()-1;
var v2=sh2.getRange(1,1,number+1,2).getValues(); 
 
tx=0;  
for(s=1;s<number+1;s++){
str=v2[s][1];
  p1=v2[s][0];
var x=str.split("）");  
for(sx=0;sx<x.length-1;sx++){ 
strx=x[sx].trim();
tx=tx+1;
univ[tx]=strx;
point[tx]=p1;  
 
}
}
 
number=tx;
 
for(s=1;s<number+1;s++){
str=univ[s];
var x1=str.split("（");
univ[s]=x1[0];
dep[s]=x1[1];
Logger.log(univ[s]+","+dep[s]+","+point[s]); 
}
 
ex = SpreadsheetApp.openById("1a6qJV1IQ2kGsiOuSmWTDBfkMEMDSOHx60G9MQhpEDm4");
sh = ex.getSheetByName("c");
 
 
for(s=1;s<number+1;s++){
sh.getRange(s+1,1).setValue(univ[s]); 
sh.getRange(s+1,2).setValue(dep[s]); 
sh.getRange(s+1,3).setValue(point[s]); 
}
 
 
}