While fun, writing code can be very tedious in that it needs to be in a specific format. I use hotstrings to replace words I frequently use but what I also realized is I often have to put parameters into specific format like a quote encapsulated/comma delimited list.
This video shows how I wrote some very simple code that makes it much easier for me to be more productive in my SQL code writing. I have other syntax writers for other languages but the concept stays the same.
Share the clipboard
I wrote a small program with AHK that allows you to share the clipboard with another computer (regardless of where it is). Sometimes I’m using my laptop and copy & then want to paste on my desktop while other times I’m collaborating with my friend in Denmark. Either case is simple for me. All I have to do on one computer is copy it to the clipboard. The other computer can simply paste and the text (or file if you’re in Windows Explorer) will be pasted!
The only requirement is to have a folder that is shared between them. (Use services like Dropbox or Google Drive or a network drive if you are at work. It has been tested on Win XP, Win 7, Win 8 and Windows 10.
Overall Explanation / Review:
How to use ClipShare:
Leveraging the Document Object Model
This third video on Web Scraping gets a little advanced and shows how you can leverage the DOM to make extracting data from a webpage much easier and reliable.
Leveraging the Document Object Model (DOM)will take some practice (especially if you’re not familiar with Object oriented coding) but it is well worth it because it greatly reduces the amount of clean-up you have to do after you extract your data. I used to write some pretty crazy regular expressions to try and clean up my code. Once I learned how to better navigate the DOM it negated the need for cleaning!
Video Leveraging the DOM plus looping over pages
The syntax for writing the writing the web scraping code can be found on my first post here. There is also an AutoHotKey forum thread you might wish to review here.
Hotkeys are a great way to be more efficient! AutoHotkey makes it easy to create a hotkey for nearly anything however you can easily create your own custom SciTE Hotkeys by making a tweak to your user.properties file.
Below is the text I have in my user.properties file which builds in hotkeys without needing AutoHotkey. You can find additional commands by going here. Just don’t forget you are not limited to these. In the video I show how you can create your own! Make sure you do not have any comments within your list. In my video I have them but I realized, later, that this causes issues.
btw- To be able to highlight text and move it up or down you can add :
#******************User defined hot key commands*****************
##################All comments need to be at end
#*****************User hotkeys end**************************************
This video walks through the process of creating your own SciTE Hotkeys