…and you obviously understand how most people think or feel challenged on the subject.

I also like the part where you encourage some tests rather than none. After a while you and your team might understand their true value, what works and what does not…

using (var reader = new StreamReader(@”c:\rejects.txt”))
{
var query = from line in reader.AsEnumerable() //skip header row
//let columns = line.Split(‘,’)
let columns = Regex.Split(line, expr)
select new
{
Firstname = columns[0],
Lastname = columns[1],
Age = columns[2]
};

“Salutation”,”First, Name”,”Middle,, Name”,”Last,,, Name”

the file is delimited by commas and fields have quotes if there is data. if there happens to be a comma in the quotes we DON”T want to split.

so i was thinking regex like this:

public static IEnumerable AsEnumerable(this TextReader reader)
{
string expr = “(?<=\”),(?=\”)”;
string line;
while ((line = reader.ReadLine()) != null)
{
yield return Regex.Split(line, expr);
}
}

dosn’t work tho.. can’t implicitly convert string[] to string.