google apps script - Find text in string, case insensitive -

-

i have made small script check expenses. in description term. search within string (like supermarket brand). unfortunately, can check case sensitive. how fix this? want search within string independent of case. search terms can upper of lower case, easy adjust.

for (i in uitgaven) {     for(n=0;n<data.length;++n)// iterate row row , examine data in column    {        if(data[n][3].tostring().match(uitgaven[i][0])==uitgaven[i][0]){ data[n][4] = uitgaven[i][1]    };  }

just substitute this:

data[n][3].tostring().touppercase()===uitgaven[i][0].touppercase()

for this:

data[n][3].tostring().match(uitgaven[i][0])==uitgaven[i][0]

Comments

Post a Comment

Popular posts from this blog

PHP while loop dynamic rowspan -

-
Image
consider table example using these table wanted print table these adding rowspan item id 1002. here php code $temp_val = ''; $counter = 1; $sql_sel = mysqli_query($con,"select * item_table"); while($res_sel = mysqli_fetch_array($sql_sel)){ if($temp_val == $res_sel['item_id']){ $counter++; echo "<tr></tr>"; } else{ echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; } $temp_val = $res_sel['item_id']; } echo "</table>"; it's not correct, it's adding rowspan item id 1003 you should switch code inside else , if statement
Read more

timer - Java TimerTask cancel -

-
i have following problem. every 2 seconds programm go inside if statement. inside if statement want have timer give me message after 15 seconds. timer should run delay of 1 second. while i'm "waiting" timer, if statement executed 7 times. problem is, have 7 same timertask @ same time running. how can solve problem? if (response == true) { final timer timer = new timer(); final int keepalivetimeout = 15000; //15 seconds timer.schedule(new timertask() { @override public void run() { if (response) { response = false; log.i(tag, "********response******"); timeoutcounter = 0; } else if (timeoutcounter > keepalivetimeout) { log.i(tag, "********timer timeout******"); } log.i(tag, "********timer******"); timeoutcounter = timeoutcounter + 1000; } }, 0, 1000); } from java api : public void schedule(timertask task, long delay, ...
Read more

android - How to read a column value in parse.com without accessing an object or a pointer -

-
by using code, not able 'name' unless use objectid = xj34weo . suggest way, if not, @ least using pointer. //parse query initialization final parsequery<parseobject> query = parsequery.getquery("myusers"); //to check row has "number"="1234" query.whereequalto("number", "1234"); query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null) { try { //xj34we0 objectid query.get("xj34weo").get("name") + ""); } catch (parseexception pe) {} } } }); are trying employee object number? you have list<parseobject> , use it. query.findinbackground(new findcallback<parseobject>() { public void done(list<parseobject> employees, parseexception e) { if (e == null && employ...
Read more