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

Using 6 built-in SciTE Find and Replace features- Great time savers!

It always amazes me of how frequently I have to manipulate text I in various ways.  More often than not it is simply doing a SciTE find and replace but being able to have other ways to manipulate text is also a great time saver!

In this video I walk through some of the tips & tricks of using SciTE search and replace text within the text editor.  I also demonstrate one of the “coolest” features which is block / typing across multiple lines.  This is a GREAT feature which many do not know how to use.  The Regular Expressions and dealing with line returns / new lines are also very helpful.


SciTE find and replace

In the video I also showed how I updated my AutoHotKey SciteUser.properties file.  Below is the line I added
#### Changing SciTE Find and Replace to posix regular expression mode so do not have to escape parens

And here are a couple of helpful pages with SciTE  documentation, SciTE RegEx documentation

Demonstration of SciTE Find and Replace Features

To avoid having to escape parens (watch above video) add the following in your SciTE user.properties file.   If set to 0, syntax uses the old Unix style where \( and \) mark capturing sections while ( and ) are themselves.  If set to 1, syntax uses the more common style where ( and ) mark capturing sections while \( and \) are plain parentheses.


Here are some useful POSIX terms which are more readable in your SciTE Find and Replace

[:xxx:] were xxx is one of the following words:
alnum    letters and digits
alpha    letters
word “word” characters (like \w)
digit    decimal digits (like \d)
space    white space
punct    printing characters, excluding letters and digits
lower    lower case letters
upper    upper case letters

(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.

Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.


What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that  are not classified (someone incorrectly used our mailing name so the RegEx broke) they can go back and update the code and all the numbers will adjust!

Automating email metrics