Yesterday while implementing a particularly difficult SQL report query, I came across the following question: Given a String ‘This is a test, this is a second test’, is there an easy method (preferably without using CLR) to search and replace the string to remove the word ‘test’ but only if it occurs as the last series of characters in a …
Tech Tip: Excel and Subtotals
If you use SUM() in Excel to calculate totals, you may want to know about the SUBTOTAL() function, which does a similar job, butbetter. SUBTOTAL takes 2 arguments – the first is a ‘magic number’, that tells it what you want to do; the second is a range of data to be totalled. Here’s what the magic numbers do: 1 …