- Notepad++
- Edit - LineOperators - Remove Empty Lines.
- Ms Word
- Ctrl+H (Replace)
- Find What ^p^p
- Replace With : ^p
- Excel - see https://www.extendoffice.com/documents/excel/4031-excel-delete-first-line-blank-lines-in-cell.html
Wednesday, September 26, 2018
How to remove empty lines?
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++;
}
}
}
//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)
}
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var start, end;
start = 1;
end = sheet.getLastRow();
sheet.deleteRows(start, end)
}
Subscribe to:
Posts (Atom)