Compression filters in Preview

Followed the guide here - very useful (note, the Filters folder needs to be in /Library, not the "user" library

https://github.com/joshcarr/Apple-Quartz-Filters

Finding differences between two columns (Excel, Libre Office)

=IF(ISERROR(MATCH(A2,$B$2:$B$2499,0)),A2,"")

Mac OS replace ';' with new line on text file

http://stackoverflow.com/questions/964945/mac-os-replace-with-new-line-on-text-file

Syntax:

cat input | tr ";" "\n"  > output