SPSS Macro is just a String Parser, this video goes over some basic usage

SPSS macro

Even in its simplest form, SPSS macros can save you an amazing amount of time by allowing you to quickly & easily swap-out one text for another. The text can be the name of a variable, the title, the statistical test to be run, etc. This can save an amazing amount of time if used properly.

In the below video gives a good demonstration of how easy it is to utilize them.

SPSS Macro is just a String Parser

SPSS Macro is just a String Parser

Automate Unicode character encoding for HTML

Unicode character encoding

Our CMS does not support Unicode text thus when we need to search-replace for characters like the and © symbols. This takes a fair amount of time and is easy to miss so I wrote a script in AutoHotKey to automatically handle the Unicode character encoding.

Now I can highlight the word and click a button and  Whamo!  Instant replacement with HTML equivalents!  No more trying to scan text and find illegal characters.

replace unicode characters with HTML equivalent

Unicode character encoding

Here is the AutoHotKey code I use.  My code first grabs the highlighted text and copies it to the clipboard, where it manipulates it, then sends it back to the active program I was working in. No more need for Unicode character encoding!

 

Example of Web Scraping- Automating Exporting of contacts from Lexis Nexis

Example of Web Scraping

Example of Web Scraping– Automating the Exporting of Data from Lexis Nexis

A few years back Lexis Nexis had access to Jigsaw (a sales list provider).  They had built in restrictions which allowed for exporting up to 1,000 contacts at a time.

Using AutoHotKey I was able to automate the exporting of contacts from Lexis Nexis into a great format.   All-told I exported over 4 million business contacts including their Name, job title, job function, email address, phone number, company name, company revenue, company NAIC code and SIC codes and much more!  It was quite a score and I was in love with Web Scraping  from then on!

Example of Web Scraping with AutoHotkey

Automating Exporting of Data

Automate LinkedIn email introductions / mesages

LinkedIn email introductionsWriting a “thank you” email in LinkedIn can be time consuming. I wrote a short script to automate the process of writing LinkedIn email introductions.

It can dynamically populate the: To, subject line and message body which will greatly increase the likelihood of someone opening and reading your email.  Suddenly you can speak to a ton more people and still look like a rockstar!

 

 

LinkedIn email introductions automated via web scraping with AutoHotkey

LinkedIn email automation

 

Linkedin Robot for Automating Social Media Marketing 2014 …

May 2, 2014 DOWNLOAD LINK: http://www.mediafire.com/download/f8tsv814ec8xhxn.