Convert between spreadsheet formats with sc-im. 1sc-im --quiet --quit_afterload --nocurses --export_csv ${file}.xlsx 2sc-im --quiet --quit_afterload --nocurses --export_tab ${file}.sc 3sc-im --quiet --quit_afterload --nocurses --export_mkd ${file}.csv 4sc-im --quiet --quit_afterload --nocurses --export_txt ${file}.tsv

Read More

Cronie The cronie program is also known as crond. Install 1sudo apt search -n ^cron Once installed, search for the service name, and start it. 1sudo systemctl list-unit-files | grep cron 2sudo systemctl enable --now $NAME Usage Show your current crontab: 1crontab -l You can put this in a file and edit it: 1crontab -l > …

Read More

Requirements vim basics Open a CSV table (I made this one with :r!sed 's/:/,/g' /etc/passwd | head). 1root,x,0,0,,/root,/bin/bash 2bin,x,1,1,,/,/usr/bin/nologin 3daemon,x,2,2,,/,/usr/bin/nologin 4mail,x,8,12,,/var/spool/mail,/usr/bin/nologin 5ftp,x,14,11,,/srv/ftp,/usr/bin/nologin …

Read More

Request a definition from the terminal. 1word='abderian' 2curl -s dict://dict.org/define:${word}: Convert a web page to markdown 1curl -sL "${url}" | html2markdown > "${file}}".md The html2markdown and html2md programs works better than any other.

Read More

rdfind: find duplicate files, then delete them, or turn them into links. Ask if a directory has duplicates (rdfind will not delete anything): 1rdfind $dir 2$EDITOR results.txt Replace the duplicated files with hard links. 1rdfind -makehardlinks true $dir

Read More

Install the package xdg-utils, then make very liberal use of the tab button. Ask Ask what type of application opens an mkv file: 1xdg-mime query default video/mkv Same with pdf: 1xdg-mime query default application/pdf Ask what file-type book.pdf uses. 1xdg-mime query filetype book.pdf Set Set the mime type of mp4 …

Read More

Find your public IP address 1dig +short myip.opendns.com @resolver$((RANDOM % 4 + 1)).opendns.com

Read More

Record Type Example A Record IPv4 Address "$domain".com AAAA Record IPv4 Address "$domain".com CNAME Alternative Address "$domain".rs, "$subdomain.$domain".com NS Nameserver ns1.fastname.com MX Email server "$domain".com TXT Literally anything "drunk giraffes can't spell" Query a host's IP and email handlers with the …

Read More

Install yt-dlp. 1yt-dlp --write-auto-sub ${url} It will default to English, but you can specify another language with the flag --sub-lang: 1youtube-dl --sub-lang sv --write-auto-sub ${url} You can list all available subtitles with: 1yt-dlp --list-subs ${url} It's also possible to skip the video and only download the …

Read More

1domain=splint.rs 2mkdir $domain 3cd $domain 4wget --recursive --convert-links --backup-converted \ 5 --page-requisites --level=inf --adjust-extension \ 6 -U "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)" \ 7 -p --mirror --html-extension --convert-links \ 8$domain

Read More