How to use partial matching in if loop in google apps script -


in problem input number of spreadsheets. loop on these spreadsheets , find particular sheet inside it. said sheet have common prefix. eg setup(xyz). setup word common. need particular sheet. know matchtype cannot used here, please let me know problem of code.

code:

function myfunction() { var ss = spreadsheetapp.openbyid("1kba8twfnx1brjttwsiydtdl"); var sheets = ss.getsheets();  if (sheets.length > 1) {   for( var in sheets){     if((sheets[i].getname()).matchtype.any == "setup(")       {logger.log(sheets[i].getname());        logger.log("hello");       }   logger.log("hello"); }

}

}

matchtype has never been in javascript. use getname().indexof("setup(")>=0


Comments

Post a Comment

Popular posts from this blog

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more

ruby - Net::HTTP extremely slow responses for HTTPS requests -

for reason, on development machine i'm getting very, slow responses https requests performed via net::http. i've tried restclient , httparty , both have same issue. seems have sprung nowhere. i've made these requests hundreds of times without issue, today unbearably slow. pry(main)> puts time.now; httparty.get('https://api.easypost.com/v2/addresses'); puts time.now; 2015-04-29 08:07:08 -0500 2015-04-29 08:09:39 -0500 as can see, response took 2.5 minutes. , it's not easypost api url. i've tried numerous ssl requests servers know can connect ( https://google.com , https://weather.com , etc.) , result in same behavior. also, noticed same thing happens requests redirected http https. now, check out non-ssl request: pry(main)> puts time.now; httparty.get('http://lookitsatravis.com'); puts time.now; 2015-04-29 08:12:22 -0500 2015-04-29 08:12:22 -0500 instantaneous. gives? guess configuration problem somewhere between ruby , openssl. i...
Read more

c# - Json write can not be serialized -

process: create player class. create player list<player>() . add players list. write json serial file. when click on writejson button receive error: "type `'editplayers.player'` cannot serialized. consider marking `datacontractattribute` attribute, , marking of members want serialized `datamemberattribute` attribute. if type collection, consider marking `collectiondatacontractattribute`.see microsoft .net framework documentation other supported types." question: how mark list<player>() collectiondatacontractattribute . class player { public int memberid { get; set; } public int gender { get; set; } public string lname { get; set; } public string fname { get; set; } public int tee { get; set; } public int team { get; set; } public int flight { get; set; } public int ohc { get; set; } public decimal hcix { get; set; } } private async void writejason_click(object sender, routedeventargs e) { ...
Read more