Posts

Showing posts from 2023

Equifax Security Controls Framework

Equifax have kindly open-sources their Security Controls Framework.  You can access it here: https://controlsframework.equifax.com/home

Learning Platforms and Courses

 We all need to upskill, but that does not need to come with a hefty pricetag. Here are some great resources to give you training and certification: Open Universities Australia Class Central Google Digital Garage Khan Academy edx Academic Earth MIT

Powershell: Why does my Google Sheet formula have a leading single quote?

I was recently writing a simple Powershell script to automatically create data in Google Sheets. I used the excellent post from  James Chambers  to show me the details of the process. The code is simple enough  1. Import-Module UMN-Google 2. Use Set-GSheetData to populate the data It all works until the Hyperlinks I created were being rendered as strings, with leading single quotes. This means they look pretty awful and I dont intend to manually correct them. #defeatsthepurpose. The solution is to force the Set-GSheetData with  -valueInputOption "USER_ENTERED"  which then overrides the default behaviour of setting the values to a string. Simple when you know how.