Bash/cmd/PS one-liners and other helpful stuff

one-liners.md

Add BOM to CSV files (to open UTF-8 CSVs correctly in Excel):

sed -i '1s/^\(\xef\xbb\xbf\)\?/\xef\xbb\xbf/' *.csv

To check if a file contains UTF-8 BOM at header:

# hexdump -n 3 -C 2.txt
00000000 ef bb bf

ef bb bf // YES

Convert PNGs to JPGs:

mogrify -format jpg -quality 90 *.png