I have an unusual workflow when copying photos from my camera's SD card to my Windows desktop. For any photos I my desktop, I want to also delete on the SD card. In this post (part 1 of 2), I describe my PowerShell script to "repeat" what I deleted on the desktop on the SD card. In my next post, part 2, I expand the PowerShell script to (try) monitor for file system changes instead.

Continue reading...

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...

Microsoft PowerPoint 2016 for Mac (aka version 15) has a strange quirk - when I copy and paste images from Preview or most other applications, the image gets copied in Tagged Image File Format (TIFF). The image is practically uncompressed (or possibly minimally compressed), resulting in very, very huge PPTX files! Plus: Removing unwanted font references.

Continue reading...

I recently had the "opportunity" to perform some text manipulation to get data from a huge log file into a spreadsheet. I had done this sort of work a long time ago as a developer, but had forgotten over the years. So I decided to compile a text manipulation cheat-sheet for macOS.

Continue reading...

Since 2012, all apps on the Mac App Store must run in an app sandbox, which restricts access to system resources unless explicitly required. The secure sandbox isolates the app and defines access controls, protecting users from malicious code with undesired behaviour.

Here's how to setup a sandbox for an app downloaded from outside the Mac App Store.

Continue reading...