• Intro to AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Painlessly switch from V1 to V2

Debug with SciTE – Reduce AutoHotkey coding time with this 1 Amazing mind blowing tool

Debug with SciTE

Debug with SciTE and AutoHotKey

Debugging can be very time consuming. If you’re using SciTE with AutoHotKey, there is built-in functionality that is very helpful.  This video walks through some of the cool debugging features in SciTE.  I also have  a second debugging with SciTE video that you should check out after watching this one.

Make sure you take the time to review both videos!  I guarantee it will increase your speed of developing code and trouble-shooting issues!

Debug with SciTE

Debug with SciTE

Below is the AutoHotKey script I used in the video:

#SingleInstance, Force
#NoEnv
Var:=0

OutputDebug Line %A_LineNumber%: A_Index is: %A_Index% and Var is: %Var%
GoSub Looper
MsgBox end of program
return

;***********************First loop********************************.
Looper:
loop, 15
{
var:=Var+A_Index
OutputDebug Line %A_LineNumber%: A_Index is: %A_Index% and Var is: %Var%
var:=Var+10
GoSub SubLooper
}
return

;***********************Sub loop********************************.
SubLooper:
Loop, 3
{
SubLooperVar:=A_Index
OutputDebug Line %A_LineNumber%: A_Index is: %A_Index% and Var is: %Var% and Sublooper index is: %SubLooperVar%
}
return

 

 

SPSS macro to remove characters from strings

SPSS macro

SPSS macro to remove characters from strings

While SPSS has many strengths, string manipulation is NOT one of them! Don’t get me wrong, you can manipulate strings however the syntax for doing so is very complex.

If you are still using an older version of SPSS, this macro shows how you can easily remove character(s) from a string both anywhere in the string or at a certain location.  Newer versions have a Replace command which can be used to remove unwanted characters.

Video demonstrating SPSS macro to remove characters from strings

 

Customize SPSS Toolbar buttons to greatly speed-up your work!

Customize SPSS Toolbar buttons to speed-up your work!

Creating customize SPSS toolbar buttons

I don’t know who set up the default toolbars but they clearly don’t work much in the “real world”!

The vast majority of work I do in SPSS is writing syntax however, having a frequency button or a button that empty’s the output screen is a lifesaver!  Unfortunately most people don’t take the time to customize their toolbars.

 

This shows how easy it is to add – delete buttons from the toolbars.  While the video shows the process on version 13 of SPSS, the same process works on newer versions.

Video demonstrating how to Customize SPSS Toolbar buttons

 

Easy way to export ZOHO contacts- API call’s are a life saver in the 21st century!

export zoho contacts

You wouldn’t think that exporting contacts from an online CRM would be difficult however when I went to export ZOHO contacts, it sure went out of their way to!  I also found trying to update them (via the web interface) time consuming and frustrating.  I wrote an API call that automated the exporting of contacts from my account.

The below video documents how the API call automated my export ZOHO contacts and then builds a hyperlink which allows me to easily link back to an individual record.  API / Web services are similar to but different than web scraping in that the API call allows you to be very specific with your query and doesn’t return all the HTML content (which greatly increases the size of the payload)

Export ZOHO contacts

You might find this Kindle book interesting if you’re migrating your database to the cloud.