I tried indexOf(), findText() and other few methods for finding a string pattern in a text in google app script. None of the above method works.
var str="task is completed";
I'm getting this string from google spreadsheet.
I just want to find whether the above string contains a string "task" .
You need to check if the str is present:
if (str) {
if (str.indexOf('task') > -1) {
// Present
}
}
Alternatively, you can use test and regex:
/task/.test("task is completed");
/task/.test(str);
/task/: Regex to match the 'task'test: Test the string against regex and return boolean
I'm getting this error message : TypeError: Cannot call method "indexOf" of undefined.a simple str.indexOf("test")>=0 does it. it works. not sure why you say it doesnt work as you havent shown any code to point out the problem.
if you want to check regardless of case use str.toLowerCase().indexOf("test")
I tried indexOf(), findText() and other few methods for finding a string pattern in a text in google app script. None of the above method works.What you need to do is make the array value a string so apps script doesn't think it's searching an array. Add double quote to your toString() function.
var arr = ["blah", "blahYES", "NOblahYES"]
for (i = 0; i < arr.length; i++){
if(arr[i].toString().indexOf("YES") > -1) {
// do something awesome.
}
}
