The below script opens an excel document in read only mode and then searches for a set string within the first sheet, cells ranging A1-AZ200. This can be amended depending on the specific documents you are searching but this is a good way of quickly searching most files. Notice the options in the open and […]Read more "Powershell: How to search an excel document for a string using com objects"
The below script opens a word document in read only mode and then searches for a set string. Notice the options in the open and close document calls which are important to open the documents in read only mode and not save on exit. The scripting lines between the open and close document lines can […]Read more "Powershell: How to search a word document for a string using com objects"
In this blog we will be installing terraform on a Centos virtual machine and then use it to create some simple infrastructure in the Azure cloud. To begin with you require a VM running Centos to install Terraform on and then we will use this to create a simple Centos small VM within Azure. First […]Read more "Install Terraform and create a simple VM in the Azure cloud"
The Azure command line interface is a way of managing your Azure resources from a command line interface. In order to do this we are going to install the Azure CLI tool on a Centos VM. To install the Azure CLI we require node.js which is not currently available via the yum command so we […]Read more "Installing the Azure CLI on a Linux virtual machine"
This is a very simple guide on how to create a virtual machine using the Azure portal. We are going to create a Centos 7 VM which is a open version of Linux. This shows you the bare minimum required to set up a virtual machine in Azure and connect to it. We will only […]Read more "Creating a virtual machine in Azure – A very simple guide"
Recently I had to execute different commands based on 3 given inputs in a truth table style. Instead of going the nested if statement route that is a little hard to read I implemented a case script that assigns a base 2 value to each ‘truth’ input. This is then used to calculate the truth […]Read more "Shell script to take in 3 inputs and execute commands using a case statement truth table"
How to write to a text output file using Powershell. The initial creation and first write: <# create File showing the exceptions found when running the tool #> $textwriter = “First text to output” $textwriter | Set-Content c:/folder/file.txt Appending additional text to the text file: <# Append the number of staff directories to the output […]Read more "Powershell: Writing to an output file"