BS

Wednesday, September 26, 2018

Sunday, September 23, 2018

RegExp


Find
Meaning
Example
[]
The square brackets can be used to match ONE of multiple characters.

[abc]
 matches any of the characters a, b or c.

[a-c]
Ranges can also be used, [a-z] is any lower case character and so on














Tuesday, September 18, 2018

Powershell - How to Comment?

Single Line :                      
# this line is single line comment


Multiple Lines :               
<#  we can enter
Multiple lines
In this comments
#>

GDrive - List Files and Folders Recursive

function ListFiles() {
 //https://developers.google.com/apps-script/reference/drive/folder-iterator

      var iRow = 1;
      var iColumn = 1;
      var CreateFileName = "101_ListFiles" //provide the excel file name
  var ssFile = SpreadsheetApp.create(CreateFileName);
  var ss= ssFile .getActiveSheet(); //Created//

     
      ss.getRange(iRow, iColumn).setValue("Folder");
      ss.getRange(iRow, iColumn + 1).setValue("FileName");
      iRow++;

 var folders = DriveApp.getFolders();
 while (folders.hasNext()) {
      var folder = folders.next();

      //file iteration
      var dApp = DriveApp;
      var folderIter = dApp.getFoldersByName(folder.getName());
   
      var folder = folderIter.next();
      var filesIter = folder.getFiles();
      //iRow++;
   
      while (filesIter.hasNext()) {
        var file = filesIter.next();
        var fileName = file.getName();
     
     
        //Logger.log(folder.getName() + " " + fileName );
        ss.getRange(iRow, iColumn).setValue(folder.getName());
        ss.getRange(iRow, iColumn + 1).setValue(fileName);
     
        iRow++;
      }
 }
}

GDrive - Delete All records in Active Sheet

function DeleteDataInActiveSheet() {

    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var start, end;

    start = 1;
    end = sheet.getLastRow();

    sheet.deleteRows(start, end)

}

Azure

  1. portal.azure.com