Григорий Боев

words = [(0,'What'),(1,'the'),(2,'heck?')]
for key,word in words:
    print('key:', key)
    print('word:', word)
    print()

key: 0
word: What

key: 1
word: the

key: 2
word: heck?

words = [(0,'What'),(1,'the'),(2,'heck?')]

for _,word in words:
    print(word)

a = {}
a[()] = 5
print(a)

{(): 5}

const printf = (str, ...params) =>
  str.replace(/\$(\d+)/g, (m, g1) => params[~-g1] ?? m);

function generateValue() {
  var spreadsheet = SpreadsheetApp.getActive();
  var from = 1;
  var to = spreadsheet.getRange('Sheet1!C5').getValue();
  var rand = randBetween_(from, to);
  spreadsheet.getRange('Sheet1!D5').setValue(rand);
}


function randBetween_(from, to){
  return Math.floor(Math.random()*(to - from + 1) + from);
}

/**
 *
 * @param {GoogleAppsScript.Events.SheetsOnEdit} e
 */
function onEdit(e) {
  const allowRanges = [
    { sheetName: 'Заглавная буква', cells: ['B2', 'B3', 'B4'] },
    { sheetName: 'Стартовая страница', cells: ['B2', 'C2', 'D2'] },
  ]; // Список
  const sheetNames = allowRanges.map(r => r.sheetName);

  if (e && e.range) {
    const sheet = e.range.getSheet();
    if (
      sheetNames.indexOf(sheet.getName()) > -1 &&
      allowRanges.find(r => r.sheetName === sheet.getName()).cells.indexOf(e.range.getA1Notation()) > -1
    ) {
      const value = '' + e.range.getValue();
      e.range.setValue(value.slice(0, 1).toLocaleUpperCase() + value.slice(1).toLocaleLowerCase());
    }
  }
}

Не работает для группы ячеек

let a = [{v: 1}, {v: 2}, {v: 3}];
for (let obj of a) {
  obj.v += 1;
}
a // [{"v":2},{"v":3},{"v":4}]

fs.writeFile(file, data[, options], callback)#
History:

• file <string> | <Buffer> | <URL> | <integer> filename or file descriptor
  
• data

  <string> | <Buffer> | <TypedArray> | <DataView> | <Object>

  
  
• options <Object> | <string>
  • encoding <string> | <null> Default: 'utf8'
    
  • mode <integer> Default: 0o666
    
  • flag <string> See support of file system flags. Default: 'w'.
    
  • signal <AbortSignal> allows aborting an in-progress writeFile
    
  
  
• callback <Function>
  • err <Error> | <AggregateError>
    
  
  
  

When file is a filename, asynchronously writes data to the file, replacing the file if it already exists. data can be a string or a buffer.

When file is a file descriptor, the behavior is similar to calling fs.write() directly (which is recommended). See the notes below on using a file descriptor.

The encoding option is ignored if data is a buffer.

If data is a plain object, it must have an own (not inherited) toString function property.
...

генерирует файлы htaccess во всех папках

find /home/.../papka_saita -type f -name ".htaccess" -delete

=INDEX(SORTN(TRANSPOSE({
  IF({B19:L19\B28:L28}="";"";--{B19:L19\B28:L28});
  TRIM(QUERY(
    IF("" & TRANSPOSE({B19:L19\B28:L28})="" & {B19:L19\B28:L28};IF({B19:L19\B28:L28}="";"";--{B19:L19\B28:L28}););
    ;
    9^9))
});9^9;2;1;1);;2)