Save a ton of time by creating a syntax writer that writes your code for you!

AutoHotKey syntax writer

Syntax Writer

While fun, writing code can be very tedious in that it needs to be in a specific format. I use hotstrings to replace words I frequently use but what I also realized is I often have to put parameters into specific format like a quote encapsulated/comma delimited list.

This video shows how I wrote some very simple code that makes it much easier for me to be more productive in my SQL code writing.  I have other syntax writers for other languages but the concept stays the same.

 

Programs that help you write programs

SPSS macro to flip ordinal variable labels so they graph well in Excel

SPSS macroEven though I do nearly all my analysis in SPSS, I still prefer to use Excel to graph my data.  Unfortunately Excel inverts the legend when graphing. Creating a new variable, or re-coding the old one, is time consuming and errors can creep in. This SPSS macro to invert an ordinal variable with very little work.  Saves an amazing amount of time!

It also has a built-in way to filter out too small a sample size.

 

SPSS macro

The below video demonstrates the usage of the SPSS macro.

Inverting an Ordinal Variable that has value labels

 

Ever want to share the clipboard between computers? Now you can!

share the clipboard

Share the clipboard

I wrote a small program with AHK that allows you to share the clipboard with another computer (regardless of where it is).   Sometimes I’m using my laptop and copy & then want to paste on my desktop while other times I’m collaborating with my friend in Denmark.  Either case is simple for me.  All I have to do on one computer is copy it to the clipboard. The other computer can simply paste and the text (or file if you’re in Windows Explorer) will be pasted!

The only requirement is to have a folder that is shared between them. (Use services like Dropbox or Google Drive or a network drive if you are at work. It has been tested on Win XP, Win 7, Win 8 and Windows 10.

Overall Explanation / Review:

ClipShare Intro – Explanation

How to use ClipShare:

ClipShare-How to use

 

Web Scraping with AutoHotKey 103-Leveraging the Document Object Model

web scraping

Leveraging the Document Object Model

This third video on Web Scraping gets a little advanced and shows how you can leverage the DOM to make extracting data from a webpage much easier and reliable.

Leveraging the Document Object Model (DOM)will take some practice (especially if you’re not familiar with Object oriented coding) but it is well worth it because it greatly reduces the amount of clean-up you have to do after you extract your data.  I used to write some pretty crazy regular expressions to try and clean up my code.  Once I learned how to better navigate the DOM it negated the need for cleaning!

The HTML Document Object Model (DOM)-Tree of Objects

Document Object Model

Video Leveraging the DOM plus looping over pages

Webscraping with AHK 103-Isolating sections and taking advantange of DOM

The syntax for writing the writing the web scraping code can be found on my first post here.  There is also an AutoHotKey forum thread you might wish to review here.