Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //not working script
- function numcharsbetweenocc2and3ofApple() {
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
- var array = ['apple', 'apple', 'apple'];
- var element = 'apple';
- var idx = array.indexOf(element);
- var string1 = sheet.getRange(2, 2).getValues().toString();
- var apple_length1 = element.length;
- var first_apple1 = string1.indexOf(element) + apple_length1;
- var second_apple1 = string1.indexOf(element, first_apple1);
- var third_apple = string1.indexOf(element, second_apple1);
- var result1 = third_apple - second_apple1;
- if (string1 !== "") {
- sheet.getRange(2, 3).setValue(result1);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement