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.

Syndicate content