在文本跳转前放置= [英] Put a = before text jump

问题描述

您好，我制作了此脚本，可将数据从列导出到Google驱动器上的.txt

Hello I made this script to export the data from a column to a .txt on my google drive

function maquinasBonusHunt() {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange('G3:G' + sheet.getLastRow());
  var rows = range.getValues().filter(([g]) => g.toString() != "");
  var fileName="maquinas.txt";
  var folderName="Videos";
  var data = rows.splice(0);
  var str = data.map(function(e) {return e.join()}).join("\n");
  var separador = [" - ", " = "];
  var content = str;

  // get list of folders with matching name
  var folderList = DriveApp.getFoldersByName(folderName);  
  if (folderList.hasNext()) {
    // found matching folder
    var folder = folderList.next();

    // search for files with matching name
    var fileList = folder.getFilesByName(fileName);

    if (fileList.hasNext()) {
      // found matching file - append text
      var file = fileList.next();
      var combinedContent = content;
      file.setContent(combinedContent);
    }
    else {
      // file not found - create new
      folder.createFile(fileName, content);
    }
  }
}

一切都很好，但我需要在前面加上"="在他们跳转到其他文本(如y)之前，请在屏幕截图上为您显示. https://i.stack.imgur.com/xvXDA.png

Everything is fine but, I need to put a "=" before they jump to other text like y show you on the screenshot. https://i.stack.imgur.com/xvXDA.png

推荐答案

我相信您的目标如下.

• 您要在每行的最后一个字符中添加=.

为了实现您的目标，我想提出以下修改.

In order to achieve your goal, I would like to propose the following modification.

在这种模式下，运行join时会添加=.

In this pattern, = is added when join is run.

var str = data.map(function(e) {return e.join()}).join("\n");

收件人:

var str = data.map(function(e) {return e.join()}).join("=\n") + "=";

模式2:

在这种模式下，使用filter后会添加=.

var rows = range.getValues().filter(([g]) => g.toString() != "");

收件人:

var rows = range.getValues().filter(([g]) => g.toString() != "").map(([v]) => [v + "="]);

参考文献:

• join()
• filter()
• map()

References:

• join()
• filter()
• map()

这篇关于在文本跳转前放置=的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！