• Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey GUIs are Easy with AutoHotkey Intro to DOS & AutoHotkey

Dallas attendance by zip code with drive-time zones- Man we wasted a lot of $

Our Dallas client was adamant that they “drew” from an enormous distance.  And, in truth, they did however when you add it all up and look at the annual attendance for the year, the vast majority of attendance came from a 30 minute drive time.

The below map shows the attendance by zip code overlayed with drive-time zones of 30 minutes, 60 minutes and 90 minutes.  The cost for purchasing mass-media, to reach the outer areas, was definitely not worth the return on investment!

Attendance by zip code

attendance by zip code

If you’re new to GIS analysis, I recommend the following book as good intro.


Here’s a great book to get ideas on conveying data visually

100 Amazing Built-in SciTE Keyboard Shortcuts & Hotkeys: Work smarter, not harder!

SciTE Keyboard Shortcuts & Hotkeys

Built-in SciTE Keyboard Shortcuts & Hotkeys

SciTE is a wonderful & powerful editor!  I love using it for AutoHotKey, Python, HTML, SPSS, SQL, XML, and more!  Below are SciTE Keyboard Shortcuts & Hotkeys  to use with SciTE .  I’ve bolded a few of the ones that I use very frequently.  You also may like to check out the documentation.   I have custom SciTE Hotkeys that I’ve added however they require updating files like the user.properties file which review in a this post.

You can download a printable version here.  In the zip file you’ll find an Excel file which you can easily manipulate to your liking or just use the PDF versions.

SciTE Keyboard Shortcuts & Hotkeys

Ctrl+Keypad+ Magnify text size.
Ctrl+Keypad- Reduce text size.
Ctrl+Keypad/ Restore text size to normal.
Ctrl+Tab Cycle through recent files.
Tab Indent block.
Shift+Tab Dedent block.
Ctrl+BackSpace Delete to start of word.
Ctrl+Delete Delete to end of word.
Ctrl+Shift+BackSpace Delete to start of line.
Ctrl+Shift+Delete Delete to end of line.
Ctrl+Home Go to start of document.
Ctrl+Shift+Home Extend selection to start of document.
Alt+Home Go to start of display line.
Ctrl+End Go to end of document.
Ctrl+Shift+End Extend selection to end of document.
Alt+End Go to end of display line.
Ctrl+Keypad* Expand or contract a fold point.
Alt+F2 Select to next bookmark.
Alt+Shift+F2 Select to previous bookmark.
Ctrl+F3 Find selection.
Ctrl+Shift+F3 Find selection backwards.
Ctrl+Up Scroll up.
Ctrl+Down Scroll down.
Ctrl+L Line cut.
Ctrl+Shift+T Line copy.
Ctrl+Shift+L Line delete.
Ctrl+T Line transpose with previous.
Ctrl+D Selection duplicate.   (Great to use in SciTE editor)
Ctrl+K Find matching preprocessor conditional, skipping nested ones.
Ctrl+Shift+K Select to matching preprocessor conditional.
Ctrl+J Find matching preprocessor conditional backwards, skipping nested ones.
Ctrl+Q Comment out line  (Great to use in SciTE editor)
Ctrl+Shift+J Select to matching preprocessor conditional backwards.
Ctrl+[ Previous paragraph. Shift extends selection.
Ctrl+] Next paragraph. Shift extends selection.
Ctrl+Left Previous word. Shift extends selection.
Ctrl+Right Next word. Shift extends selection.
Ctrl+/ Previous word part. Shift extends selection
Ctrl+\ Next word part. Shift extends selection.
Alt+Shift+Movement Rectangular block selection.
Alt+Shift+Home Extend rectangular selection to start of line.
Alt+Shift+End Extend rectangular selection to end of line.

 

SciTE Keyboard Shortcuts

(Regular Expressions) RegEx to clean text| Mind-blowing ways to clean up your text in 2021!

RegEx to clean text

RegEx to Clean Text

I used to work in Market Research and would spend hours cleaning up labels from surveys I’d programmed in online tools. The below video shows how easy it can be if you understand regular expressions and a little programming.

Regular Expressions can have a steep learning curve however it is really worth it if you continually get data that you need to clean.  You can also check out this post of mine showing how they can be used to automate your metrics.

RegEx to clean text demo

A handy cheat-sheet is downloadable from here and a wonderful course from Kevin Skoglund available from Lynda.com is available here.  Below is a great intro to the Regular Expressions.

Regex to clean text in preparation for word count in PHP – Code …

Jan 25, 2014 … a question; Anybody can answer; The best answers are voted up and rise to the top. Regex to clean string in preparation for word count in PHP …

php – Match all youtube links in a string of text – Code Review Stack …

Apr 7, 2015 Regular expressions to clean text in preparation for word count in PHP · 0 · Remove parameters from string containing URL · 4 · Normalizing strings using …

php – Regex to remove inline javascript from string – Code Review …

Aug 21, 2013 Regex to clean text in preparation for word count in PHP · 2 · Regex-ing an array · 2 · Removing stray brackets from in between shortcodes.

Web Scraping with AutoHotKey 101-Super simple ways to Get data from a page, handles & pointers

Web Scraping with AutoHotKey

Web Scraping with AutoHotkey: Intro

Being able to, programatically, navigate to an Internet page and scrape the contents in a reliable fashion is best things invented since sliced bread!   I spent years manually going through pages and copying/pasting contents from IE to Excel then spent even more time trying to clean it up.  Done properly you can get the data very, very close to how it is on the web with little effort.

The below video walks through using AutoHotKey to obtain basic values from a Web page.  It also demonstrates a script I wrote that helps write the syntax (yes I’m that lazy!)  The AutoHotKey script I wrote is further down this page and can also be found on the AHK forum here.

In this beginning tutorial I how to:
1) get a pointer to IE
2) navigate to a page
3) get text from a page

Web Scraping Intro with AutoHotkey

Here is the script writer to use during your web scraping intro with AutoHotkey.
Web Scraping with AutoHotKey

  • Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey GUIs are Easy with AutoHotkey Intro to DOS & AutoHotkey