CSV Parser in one routine/function?

Question

I know there are several libraries of code out there that can parse CSV files according to the standard, but, for various reasons, I need one simple routine (not an entire library) that parses a CSV into a DataTable or array. Does such an animal exist or is it extinct? (Preferably C# but i can translate vb.net too)

Answer 1

Write your own method that loops through each line and use the split method using the comma as your delimiter.

If you want to parse a csv using linq, here is a simple example:

http://www.fryan0911.com/2009/05/read-data-from-csv-using-linq.html

Answer 2

Reference Microsoft.VisualBasic and you can use TextFieldParser

using (var parser =
    new TextFieldParser(@"c:\data.csv")
        {
            TextFieldType = FieldType.Delimited,
            Delimiters = new[] { "," }
        })
{
    while (!parser.EndOfData)
    {
        string[] fields;
        fields = parser.ReadFields();
        //go go go!
    }
}