Issue if string includes substring

Question

I want to check if a substring is in a string.

The string come from the 12th row of a Google sheet. The substring come from an HTML form where the user inserts data. (It's a simple string in the example below and it still doesn't work. The problem is not the data inserted.)

I want to display the row number of the string when the substring is detected.

for (var i=0; i < sheetDataRange.getValues().length; i++) {
  if (sheetDataRange.getValues()[i][11].includes("I14")) { // The string value is okay
    SpreadsheetApp.getUi().alert(i+5); // The data starts at the 5th row
  }
}

I tried to resolve the issue with the includes() function. The issue is that some rows without "I14" are displayed and other with it are not. I tried to use the match() function too but it doesn't work.

Thanks for your help.

The string come from the 12th row but getValues()[i][11 is 12th column not a row. And actually you're using terribly wrong the method getValues(). Try @Cooper's solution. — Yuri Khristich
– Yuri Khristich, Commented Aug 2, 2021 at 9:51
funkizer, Yes, sure about it. The issue is in the condition. Yuri, I used the wrong word. The string comes from somewhere in the 12th column. Not row — SuggestMeUsernames
– SuggestMeUsernames, Commented Aug 2, 2021 at 10:52

Yuri Khristich · Accepted Answer · 2021-08-02 09:55:26Z

1

You only need to getValues() once not everytime you go through the loop

const values = sheetDataRange.getValues();
const ui = SpreadsheetApp.getUi();
for (var i=0; i < values.length; i++) {
  if (values[i][11].toString().includes("I14")) { 
    ui.alert(i+5); // The data starts at the 5th row
  }
}

edited Aug 2, 2021 at 9:55

Yuri Khristich

14.6k3 gold badges11 silver badges25 bronze badges

answered Aug 1, 2021 at 17:55

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue if string includes substring

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related