Blog

Articles, code snippets and news worth sharing.

SnippetMar 18, 2012
Visual Studio Code Formatting
Control how Visual Studio formats your C# code and format a whole document with one shortcut.
1 min read#C##Visual Studio
SnippetMar 17, 2012
jQuery Split String
Split a string on a delimiter using the built-in JavaScript split function.
```
var split = 'john smith#5551234567'.split('#');

var name = split[0];   // john smith
var mobile = split[1]; // 5551234567
```
1 min read#JavaScript#jQuery

SnippetMar 17, 2012

jQuery Remove Select Tag Duplicates

Remove duplicate options from a select element with a short jQuery loop.

var usedDisplayNames = {};
$("select[name='tagname'] > option").each(function () {
    if (usedDisplayNames[this.text]) {
        $(this).remove();
    } else {
        usedDisplayNames[this.text] = this.value;

1 min read#JavaScript#jQuery

SnippetMar 17, 2012
Excel Comma Separated Column Values
Join the values of an Excel column into one comma separated string using a simple running formula.
```
B2 = A1 & ", " & A2
B3 = B2 & ", " & A3
```
1 min read#Office#Tools
SnippetMar 17, 2012
C# Inheritance
The syntax of class inheritance in C# and the main rules to remember.
```
class A
{
    int aVariable;
    public A()
    {
    }
```
1 min read#.NET#C#

SnippetMar 15, 2012

SQL Proper Casing

A T-SQL user defined function that converts text to proper case, capitalising the first letter of every word.

CREATE FUNCTION ProperCase(@inpStr nvarchar(8000))
RETURNS nvarchar(8000) AS
BEGIN
     DECLARE @Result nvarchar(8000)
     SET @inpStr = LOWER(@inpStr) + ' '
     SET @Result = ''

1 min read#SQL

Blog

Posts

Visual Studio Code Formatting

jQuery Split String

jQuery Remove Select Tag Duplicates

Excel Comma Separated Column Values

C# Inheritance

SQL Proper Casing