Debug with SciTE – Reduce the amount of coding time in AutoHotKey

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 AutoHotKey with SciTE

Debug with SciTE

Below is the AutoHotKey script I used in the video:

 

 

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

 

Removing charchters from strings in SPSS

Customize SPSS Toolbar buttons to 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

Creating custom toolbar buttons in SPSS

Easy way to export all of your ZOHO contacts- API call’s are a life saver!

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

ZOHO API Call-Exporting all Records

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