Advertisement
Lodscripts

20190619 JescanellasScript 3 occurences

Jun 19th, 2019
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //not working script
  2.  
  3. function numcharsbetweenocc2and3ofApple() {
  4.  
  5. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
  6.  
  7. var array = ['apple', 'apple', 'apple'];
  8. var element = 'apple';
  9. var idx = array.indexOf(element);
  10.  
  11. var string1 = sheet.getRange(2, 2).getValues().toString();
  12.  
  13.  
  14. var apple_length1 = element.length;  
  15. var first_apple1 = string1.indexOf(element) + apple_length1;
  16. var second_apple1 = string1.indexOf(element, first_apple1);
  17. var third_apple = string1.indexOf(element, second_apple1);
  18.  
  19.  
  20. var result1 = third_apple - second_apple1;
  21.  
  22. if (string1 !== "") {
  23.       sheet.getRange(2, 3).setValue(result1);
  24.     }  
  25.  
  26.  
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement