A bash script to search a CSV file

19 May 2018macosbashregex

I sometimes need to search a huge CSV file (13 MB), containing 21,000 rows and roundabout 40 columns, which Numbers takes half a minute to open. All I need to do is search and display the results of a few columns only... so I wrote a bash script to do this for me - and I was quite specific in that I wanted the results in color!

Continue reading...

Fixing PowerPoint Slide Show on External Monitor

27 Jan 2018macospowerpoint

I've been experiencing this problem for a while - when presenting using Microsoft PowerPoint for Mac 2016 (version 15) on an external monitor (or LCD projector), PowerPoint used to both the presentation slide show and the Presenter View on my notebook display, instead of Presenter View on the notebook and the full-screen slide show on the external monitor. Recently, I found the solution!

Continue reading...

Converting JSON into CSV

29 Dec 2017macosbashjq

Recently I needed to analyze some JSON data. Now, I'm no data scientist, so I wanted to convert my JSON data to comma separated (CSV) and "flatten" the data... just so I could use the data in Excel.

And Merry Christmas and Happy New Year!

Continue reading...

Installing High Sierra in a Parallels VM

20 Oct 2017macosparallels

When macOS High Sierra was released around 25th September, I tried to install it in Parallels Desktop Lite. However, both a clean install in a Parallels Virtual Machine (VM), nor an in-place update did not work (the High Sierra VM would refuse to boot). I discovered the High Sierra installer converts the VM file system to Apple File System (APFS). However, Parallels does not support APFS, so here's how to disable the conversion and get High Sierra running in a Parallels.

Continue reading...