首页 \ 问答 \ 如何使用replace替换字符串中的所有匹配字符？(How to replace all the matched characters in a string using replace?)

如何使用replace替换字符串中的所有匹配字符？(How to replace all the matched characters in a string using replace?)

 我使用了一种方法来格式化Google Apps脚本中的日期，以便它只读取MMM dd, yyyy 。 我试图用“”替换日期字符串中的所有“ - ”，但使用替换方法仅替换字符串中的第一个“ - ”，其余部分都没有。 任何想法，为什么这是？ 我怎样才能取代我的字符串中的所有“ - ”？  
 这是我的代码：  
function formatDate() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var dataSheet = ss.getSheets()[0];
  var templateSheet = ss.getSheets()[1];
  var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() - 1, 9);

  var data = dataRange.getValues();
  var startRow = 2;  // First row of data to process
  var objects = getRowsData(dataSheet, dataRange); 

  //Format date in column D
  for(var k=0; k<objects.length; k++){
    var column = data[k];
    var DateCell = column[4];
    var emailSent = column[8];


    var column = data[k];
    var DateCell = column[4];
    var date = new Date(DateCell).toLocaleDateString('en-US',{
      day : 'numeric',
      month : 'short',
      year : 'numeric'
      }).split("").join("-").replace(/-/g, "");

    var Date1 = dataSheet.getRange(startRow + k, 5);
    var Date2 = dataSheet.getRange(startRow + k, 6);
    Date1.setValue(date);
    Date2.setValue(date);
   }
}

I have a method I am using to format the date in a Google Apps Script so that it just reads MMM dd, yyyy. I am trying to replace all the "-"s in my date string with "" but using the replace method only replaces the first "-" of the string and none of the rest. Any thoughts as to why that is? How can I get it to replace all the "-" in my string? 
Here is my code: 
function formatDate() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var dataSheet = ss.getSheets()[0];
  var templateSheet = ss.getSheets()[1];
  var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() - 1, 9);

  var data = dataRange.getValues();
  var startRow = 2;  // First row of data to process
  var objects = getRowsData(dataSheet, dataRange); 

  //Format date in column D
  for(var k=0; k<objects.length; k++){
    var column = data[k];
    var DateCell = column[4];
    var emailSent = column[8];


    var column = data[k];
    var DateCell = column[4];
    var date = new Date(DateCell).toLocaleDateString('en-US',{
      day : 'numeric',
      month : 'short',
      year : 'numeric'
      }).split("").join("-").replace(/-/g, "");

    var Date1 = dataSheet.getRange(startRow + k, 5);
    var Date2 = dataSheet.getRange(startRow + k, 6);
    Date1.setValue(date);
    Date2.setValue(date);
   }
}

原文：https://stackoverflow.com/questions/43462069

更新时间：2022-12-04 08:12

最满意答案

 您可以使用FirstOrDefault()来选择符合特定条件的第一个项目，如果没有这样的项目，则选择null 。  
var firstNotExpired = fruits.OrderBy(f => f.time)
                            .FirstOrDefault(f => !(f.status == "Expired" || 
                                                   f.status == "Cancelled"));
 
 这很好，简洁，但效率低下，因为它需要对整个列表进行排序。 这更有效率：  
var firstNotExpired = fruits.Where(f => !(f.status == "Expired" || 
                                          f.status == "Cancelled"))
                            .OrderBy(f => f.time)
                            .FirstOrDefault();

You can use FirstOrDefault() to select the first item that meets certain criteria, or null if there is no such item. 
var firstNotExpired = fruits.OrderBy(f => f.time)
                            .FirstOrDefault(f => !(f.status == "Expired" || 
                                                   f.status == "Cancelled"));
 
That's nice and concise, but inefficient because it requires sorting the whole list. This is more efficient: 
var firstNotExpired = fruits.Where(f => !(f.status == "Expired" || 
                                          f.status == "Cancelled"))
                            .OrderBy(f => f.time)
                            .FirstOrDefault();

如何使用replace替换字符串中的所有匹配字符？(How to replace all the matched characters in a string using replace?)

最满意答案

相关问答

SQL - 选择按日期排序的最后一行(SQL - selecting last row ordered by a date)[2022-11-16]

sql，按列A排序，然后按列B排序(sql, order by column A and then by column B)[2023-07-14]

Android应用内结算。(Android In-App Billing. Cancelled subscription is active even after expiration date)[2021-12-20]

Linq获得按最早日期排序的第一行，并且列B未被“过期”或“已取消”(Linq get first row ordered by soonest date and where column B is not “Expired” or “Cancelled”)[2023-08-20]

如何选择按日期排序的具有不同列值的行？(How to select rows with distinct column value ordered by date?)[2021-11-03]

有序字典和排序(Ordered Dictionary and Sorting)[2022-10-11]

Google表格 - 根据日期删除过期的行(Google Sheets - Delete Expired Rows Based On Date)[2022-06-30]

列“expired_date”的类型为date，但表达式的类型为text(column “expired_date” is of type date but expression is of type text)[2022-05-31]

如果列B是最早的日期，则在列A中显示值。(Displaying values in a column A if column B is the oldest date.)[2023-12-18]

如何在午夜后找到最快的Java Date？(How do I find the soonest Java Date past midnight?)[2022-04-30]

相关文章

最新问答