单引号的串联Google脚本 [英] Concatenation of single quote marks Google Script

问题描述

我有三列数据

selector                                            label     option list
time you personally have been engaged with uscan    label_1   Arts
time you personally have been engaged with uscan    label_2   Children’s Issues
time you personally have been engaged with uscan    label_3   Coaching
time you personally have been engaged with uscan    label_4   Community Development
time you personally have been engaged with uscan    label_5   Conflict
time you personally have been engaged with uscan    label_6   Consulting

我试图将这些列连接起来，以便在第4列中得到

I am trying to concatenate these columns so that in the 4th column I get

option {
label: "Label_1;
selector: ["time you personally have been engaged with uscan"="Arts"];
}

option {
label: "Label_2;
selector: ["time you personally have been engaged with uscan"="Children’s Issues"];
}
etc

我的尝试

result[i] = [""option {label:""" + values[i][0] + "";" + "selector: [" + values[i][0] + ""=" +  + values[i][1] + ""];}"];

以所有必需的单引号填充

Foiled by all the single quotes that are required

谢谢

GS

function OptionsList() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OptionList");
  var lr = sheet.getLastRow();
  var values = sheet.getRange(2, 1, lr,3).getValues();
  var result = [];

  //Add items to results
  for(var i=0; i<lr; i++){

    result[i] = [""option {label:""" + values[i][0] + "";" + "selector: [" + values[i][0] + ""=" +  + values[i][1] + ""];}"];

}

//Post back to column 4 starting on row 2
sheet.getRange(2, 4, lr, 1).setValues(result);
}

推荐答案

此修改如何?

• 关于result[i]
  • "像\"一样逃脱了.
  • 添加了换行符，如\n.
  • About result[i]
    • " was escaped like \".
    • Line break was added like \n.

    function OptionsList() {
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OptionList");
      var lr = sheet.getLastRow();
      var values = sheet.getRange(2, 1, lr, 3).getValues();
      values = values.filter(function(e){return e[0] && e[1] && e[2]}); // Added
      var result = [];
      //Add items to results
      for(var i=0; i<values.length; i++){ // Modified
        result[i] = ["option {\nlabel: \"" + values[i][1] + ";\n" + "selector: [\"" + values[i][0] + "\"=\"" + values[i][2] + "\"];\n}"]; // Modified
      }
      //Post back to column 4 starting on row 2
      sheet.getRange(2, 4, result.length, 1).setValues(result); // Modified
    }
    

    注意:

    • 例如，是否要求在label: "Label_1;的"Label_1之后是"?如果需要，请进行以下修改.
      • + values[i][1] + "\";\n"

      Note :

      • For example, is it required to be " after "Label_1 of label: "Label_1;? If you want, please modify as follows.
        • + values[i][1] + "\";\n"
        • filter()

        如果我误解了您的问题，请告诉我.我想修改它.

        If I misunderstand your question, please tell me. I would like to modify it.

        这篇关于单引号的串联Google脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！