Larry Steinle

January 30, 2011

String.Split On Steroids

Filed under: RegEx,VS.Net — Larry Steinle @ 9:25 am
Tags: , , , , ,

The String.Split function uses a separator to divide a string value into an array of string values. Unfortunately the split function does not support text qualifiers. As a result, if the separator is contained within a text qualified block of characters, the text block gets split.

In this article we will create a new extension called, FullSplit, that will implement the same basic functionality of the String.Split function with the added support of text qualifiers and assignment operators. When assignment operators are used the return value will be of type StringDictionary where the left side of the operator represents the DictionaryEntry.Key property and the right side represents the DictionaryEntry.Value property.

Finally we will conclude the article by updating the code from a previous post, Extending IEnumerable, to support dictionary entries by separating the key/value pair with an operator.

(more…)

Advertisements

January 25, 2011

Extending IEnumerable

Filed under: VS.Net — Larry Steinle @ 11:57 pm
Tags: , , , , , , , ,

Often there is the need to take a string value and split it into an array of values. String.Split provides a quick and convenient method to split strings (as long as you don’t have to worry about text qualifiers). Today I ran into the opposite scenario. I needed to combine the different iterations of an array into a single string value.

Immediately my mind turned to extensions. A beautiful, simple and elegant solution.
(more…)

Can’t Find System.Runtime.CompilerServices.Extensions in VS.Net 2010

Filed under: VS.Net — Larry Steinle @ 10:49 pm
Tags:

We’ve all been there. It’s that silly, nagging thing that slows you down. You know the answer is obvious but you just can’t figure it out in a second. You know the developer beside you will point it out in an instant if you show them but your too proud to say anything.

It happens to all of us at one time or another…And another…And another. I digress…
(more…)

January 20, 2011

Introduction to Pivoting Data in SQL Server

Filed under: SQL Server — Larry Steinle @ 10:11 pm

A normalized database encourages the storage of information in a key/value format. That’s great for data lookup and storage operations but not always the best for usability. Pivoting data allows one or more rows of data to be organized by columns instead of by row.
(more…)

Create a free website or blog at WordPress.com.