unable to match value using indexof

Asked Oct 01 '20 at 08:03

Active Oct 01 '20 at 08:20

Viewed 50 times

I have an array picked from a google spreadsheets.

Now I have a single object from a different array arr[0][0] which is equal to an element present in the main array data.

Here is my code:-

function userClickedComp(arr)
{
  var today = new Date();
  var year = today.getFullYear();
  var ss2 = SpreadsheetApp.openById('1KtCHHj7CwXe6EOyMp_CgLAy2xFhOX2QrzyWetELhPMc');
  var name = "L.Balance."+year;
  var sheet1 = ss2.getSheetByName(name);
  var lastrow = sheet1.getLastRow();
  var data = sheet1.getRange("A1:A"+lastrow).getValues();
  
  var pos = data.indexOf(arr[0][0]);
  console.log(data+"......."+arr[0][0]+"........"+pos)
}

Here is my console.

As you can see its giving me -1 but the matching value exists in the array.

asked Oct 01 '20 at 08:03

Mask

What does `console.log(data,".......",arr[0][0],"........",pos)` say? – mplungjan Oct 01 '20 at 08:06
What's in arr[0][0] ? object or string ? – keshav Oct 01 '20 at 08:08
its there in the image "supreet" and "-1" – Mask Oct 01 '20 at 08:09
`pos = "-1"` and `arr[0][0] = "supreetsingh"` – Mask Oct 01 '20 at 08:13
Can you help with dummy data in the same format , so that community here can help in better way ? Better create a sandbox and share. – keshav Oct 01 '20 at 08:17

unable to match value using indexof

0 Answers0