Microsoft Word has a very powerful search / replace feature (and a bit easier for most to play with than a Regular Expression). One of the things I use it for is to select email addresses from a a document.
The following needs to be added to the search field: [A-Za-z0-9-._]{2,}[@]{1}[A-Za-z0-9-._][A-Za-z0-9-._][@]1[A-Za-z0-9-._]
Don’t forget to turn on Wildcards!
ransfer Systems regardless of their sourcesOur clients enter campaigns into a SharePoint page that need to be transferred to our CMS. Unfortunately the two systems are not tied in any way and there are no existing API Web Services that we can leverage.
There are over 250 items that might be selected which means we end up taking a lot of time to, manually, transfer the campaigns.
I wrote a script with AutoHotKey that automates much of the process (as well as replacing Unicode values with their HTML equivalents). This allows me to transfer systems automatically with very little effort!
This saves a TON of mundane time by performing web scraping with AutoHotkey and is more reliable than doing it manually.
In market research I used to spend a lot of time making sure my charts and graphs were beautiful visualizations that conveyed the data in an easy to understandable way.
I always wanted to make complete use of the range of the graph and would have to, manually, update each one. I finally learned some object oriented programming and wrote an script in AutoHotKey to easily change the axis on scales in and easily update Excel graphs. The below video demonstrates how I can just hit a key combo and scroll up/down to adjust the scale.
