Monthly Archives: January 2015

Having previously ruminated on the Left, Right and Middle functions, then the LeftWords, RightWords, and MiddleWords functions, we’re going to wrap up with a third triad of functions, namely LeftValues, RightValues, and MiddleValues. Before we dig into the functions though, a definition … Continue reading →

Last week we looked at the Left, Right, and Middle text parsing functions. These are extremely useful when you need to parse out highly regular data like, say, a telephone number where you can count on the first three characters to be … Continue reading →

Text parsing pops up a lot when migrating data from an old system to a new one, or even when you realize that your data just needs some grooming. Whatever the impetus, Left, Right, and Middle are the cornerstones of … Continue reading →

Sign is a nice example of a compact, efficient function that can really cut down the length of certain calculations. Its utility is simply this: check a number and report whether it’s negative, zero, or positive. Sign accepts just one parameter … Continue reading →