indexOf not working despite value is present in array

Question

I have a very simple script to check if the array contains a link. here is my code:-

var ss = SpreadsheetApp.openById('1MaxxxxxxxxxxxxxxxxxSPg');
  var sheet = ss.getSheetByName('Referral Forms');
  var lastrow = sheet.getLastRow();
  var data = sheet.getRange("L1:L" + lastrow).getDisplayValues();  
  
  var index = data.indexOf(arr.link);

  Logger.log(arr.link)    
  Logger.log(data)
  Logger.log(" index:"+index)

My log shows value is present but its index is showing -1. One thing I noticed that my value contains special characters can that be the reason?

here is a snapshot of my logs:-

Does this answer your question? [Why indexOf in javascript not working?](https://stackoverflow.com/questions/33851903/why-indexof-in-javascript-not-working) — Always Helping, Aug 08 '20 at 02:55
@AlwaysHelping This doesn't seem to be anything like that question. — Barmar, Aug 08 '20 at 02:56
There are lots of questions about indexOf, they're not all the same problem. — Barmar, Aug 08 '20 at 03:00
Problem is that second variable in array has array type with one element equal your link, but the first variable has a string type — Fakt309, Aug 08 '20 at 02:58

score 0 · Accepted Answer · answered Aug 08 '20 at 02:52

0

data is a 2-dimensional array. Every element is an array, but arr.link is a string.

You can use map() to unwrap the strings from the arrays.

data = sheet.getRange("L1:L" + lastrow).getDisplayValues().map(x => x[0]);

answered Aug 08 '20 at 02:52

Barmar

741,623
53
500
612

Duplicate of [this](https://stackoverflow.com/questions/33851903/why-indexof-in-javascript-not-working) – Always Helping Aug 08 '20 at 02:55
They don't seem to be at all alike to me. – Barmar Aug 08 '20 at 03:00

indexOf not working despite value is present in array

1 Answers1