Downloading backups from remote hosts
rsync -av --delete -e 'ssh -p 223' user@host:/dir1 local_dir
#soft #linux
Google Sheets: Bulk delete
Tools > Script ediotr Set a breakpoint at console log sheet name and Debug.
function DeleteAllSheets() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
console.log("Doc: " + ss.getName());
var sheets = ss.getSheets();
for (i = 0; i < sheets.length; i++) {
switch(sheets[i].getSheetName()) {
case "21-01":
break;
default:
console.log("Delete: " + sheets[i].getSheetName());
ss.deleteSheet(sheets[i]);
}
}
}
https://spreadsheetpoint.com/delete-multiple-sheets-google-sheets/
#soft
Convert ssh2 public key to openssh format
If the pub key is in the format
---- BEGIN SSH2 PUBLIC KEY ----
then you can convert it with
ssh-keygen -i -f klucz.pub >> ~/.ssh/authorized_keys
#soft #linux