All blog posts on the front page.
Purpose of the valueOf() Function Let me start off by explaining the commonly misunderstood valueOf() function. The purpose of this function is to return a primitive which represents the specified object. Why is this necessary? Let’s use the following code to illustrate why: If you were to execute this code, Read more…
Unfortunately, after googling for a while, I was unable to find a COALESCE function or something similar that natively exists within Excel. Therefore, I decided to write a quick-and-dirty formula that would approximate it. I used the following array formula to pull the first non-blank value from cells C2 to Read more…
One of the nice things about JavaScript is its functional nature. This is especially nice when it comes to dealing with strings and regular expressions. For instance, in JavaScript, you can use the following code to capitalize every other letter in a string: Cool stuff, right? Wouldn’t it be nice Read more…
One of the things that is often used in the JavaScript Prototype library is the camelize function which camel-cases the specified string. Unfortunately, just as this function doesn’t exist natively in JavaScript, it also doesn’t in VBScript. If you do need an equivalent function to that which is available in Read more…
One thing that I often have to do is convert a subquery into a string that is delimited by a comma. For example, I may need to write a quick report that shows the users’ names, their login ID, and all of the roles that they fulfill. In this case, Read more…
Here is a little snippet that you may find useful if you ever have to randomize the contents of an array: Here is an example of how to use it with an array: The above example will show the names that are in the names array in random order. If Read more…
In VBScript, there is a space function which takes an integer and returns a string with the specified number of spaces. At times, you may need such a function to make you text look neat while working with a monospace font. Here is the code that you could use to Read more…
If you have ever written JavaScript for a web page, one of the first things that you learned may have been that the window object is basically a reference to the global scope. On the other hand, if you have ever programmed in JScript (Windows Scripting Host), you will know Read more…
As a follow-up to my previous article about the AND (&&) and OR (||) logical operators, I decided to create to Array prototype functions that mimic these operators to a certain degree: Here are two examples of using a series of AND (&&) operators and then doing the same thing Read more…
It seems that one of the top complaints about the Array.prototype.forEach() function is the fact that there is no easy way to break out of the loop. If you are one of those people that would like to see an implementation, here you go: Calling this function would be similar Read more…