Command line
Counting the number of times values appear in one column of a spreadsheet
To do this I saved the spreadsheet as a CSV file, then used the textutils on it:
cut -d, -f16 spreadsheet.csv | sort | uniq -c
Finding an ASCII value using the Unix command line
To find the ASCII value of the letter P in decimal:
echo -n P | od -A n -t u1
Probably not Unix’s finest one-liner, but I needed it just now and hopefully I’ll never need to figure this out again.
