G脚本-如何在G盘中查找文件名的一部分 [英] G Script - How to find part of filename in G Drive

问题描述

如何在G App脚本中的文件名中搜索特定文本?我的完整文件名为每日股票摘要报告Kadlunga20180426_061749_946.pdf".我想搜索所有带有字符串"Daily Stock Summary Report Kadlunga"的文件，并将其复制到G Drive中的文件夹名称"Kadlunga".我当前的代码适用于完整的文件名.我不确定如何对p [art of filename.

How to search for a particular text in a filename in G App Script? My full File name is "Daily Stock Summary Report Kadlunga20180426_061749_946.pdf". I would like to search for all file with the string "Daily Stock Summary Report Kadlunga" and copy it to folder name "Kadlunga" in G Drive. My current code works for the full file name. I am not exactly sure how to do this for p[art of the filename.

function moveFile() {

 var dApp = DriveApp;
 var folderIterator = dApp.getFoldersByName("Attachments");

 var folder = folderIterator.next();
 var filesIterator = folder.getFiles();

 var Kadlunga = folder.getFoldersByName("Kadlunga").next(); 
 var Napperby = folder.getFoldersByName("Napperby").next();



while (filesIterator.hasNext()){
   var file = filesIterator.next();

   var fileName = file.getName();   

    if(fileName == "Daily Stock Summary Report 
         Kadlunga20180426_061749_946.pdf") 
          {
             file.makeCopy(Kadlunga);   
          } 
        if(fileName == "Daily Stock Summary Report 
         Napperby20180426_061749_958.pdf") 
         {
             file.makeCopy(Napperby);   
         }

      }

  }

推荐答案

此修改如何?

• 使用 searchFiles()，检索文件名包括每日库存摘要报告的文件.
• 使用 indexOf()将文件分类并导入到 Kadlunga 和 Napperby 的文件夹中.

• Using searchFiles(), files with the filename including Daily Stock Summary Report are retrieved.
• Using indexOf(), files are categorized and imported to the folders of Kadlunga and Napperby.

function moveFile() {
  var dApp = DriveApp;
  var folderIterator = dApp.getFoldersByName("Attachments");
  var folder = folderIterator.next();
  var filesIterator = folder.searchFiles('title contains "Daily Stock Summary Report"');
  var Kadlunga = folder.getFoldersByName("Kadlunga").next(); 
  var Napperby = folder.getFoldersByName("Napperby").next();
  while (filesIterator.hasNext()) {
    var file = filesIterator.next();
    var fileName = file.getName();   
    if (fileName.indexOf("Kadlunga") > -1) {
      file.makeCopy(Kadlunga);
    }
    if (fileName.indexOf("Napperby") > -1) {
      file.makeCopy(Napperby);
    }
  }
}

注意:

• 请根据您的环境修改此脚本.
• searchFiles()
• indexOf()

如果我误解了你的问题，对不起.

If I misunderstand your question, I'm sorry.

这篇关于G脚本-如何在G盘中查找文件名的一部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！