Home Archive by category "Text Manipulation" (Page 12)

Category: Text Manipulation

Web Scraping and emailing data to client via Outlook

Web Scraping and emailing dataWeb Scraping and emailing data

Do you frequently  access a Web page / then have to write an email regarding the data you gathered?  I had to look at our SharePoint and then email clients based on what I found.   The email is sent via Outlook and is tailored, specifically, to my client.  Saves me a ton of time!

It is easy to use AutoHotKey to read various aspects of a SharePoint site and write custom emails tailored to the respondents.

Web Scraping and emailing data video demonstration

https://www.youtube.com/watch?v=YSe0kky9AzM

Using a strong Naming Convention & RegEx are keys to automating metrics!

naming conventions

Naming Convention and Regular Expression (RegEx)

Having a strong naming convention can make reporting on your metrics a breeze when you use a regular expression to break out-decrypt the naming scheme. This video shows how easy it is for us to extract: Region, Language, Campaign Type, etc. from our campaign names by using a regular expression. It also points out that there is no need to be stuck with poor acronyms for your reporting.Group of coworkers seated around a table in a bright office, talking together with a green reusable water bottle in front of them

In my above example I use AutoHotKey with Excel.  If you add the function, Excel can do RegEx itself however (for some crazy reason) it isn’t built into it.

Paste plain text- Use 7 lines of AutoHotKey to easily strip complex RTF/HTML formatting

Paste plain text

I (Group of coworkers seated around a table in a bright office, talking together with a green reusable water bottle in front of themlike everyone else in the world) frequently copy-paste between various programs. While some programs like Word and Excel allow for paste plain text, a lot do not.

Paste plain text

I wrote a small script in AutoHotKey which takes the contents of the clipboard and strips it of HTML/RTF format. This way it allows me to paste as plain text in any program by hitting a key combination (Control+G).  What’s great is that I don’t actually lose the original format so, if I decide I actually wanted the original content, I can still just paste with Control+V and I’m good to go!

Below is the actual code to paste plain text in AutoHotKey.

paste plain text