I was wondering if anyone knew of an efficient c# function for reading a tab delimited file into a datatable?
Thanks
See Question&Answers more detail:osI was wondering if anyone knew of an efficient c# function for reading a tab delimited file into a datatable?
Thanks
See Question&Answers more detail:osThis currently uses the LINQ methods .First()
and .Skip()
both are easy to recreate if you need to use this on .Net 2.0
//even cooler as an extension method
static IEnumerable<string> ReadAsLines(string filename)
{
using (var reader = new StreamReader(filename))
while (!reader.EndOfStream)
yield return reader.ReadLine();
}
static void Main()
{
var filename = "tabfile.txt";
var reader = ReadAsLines(filename);
var data = new DataTable();
//this assume the first record is filled with the column names
var headers = reader.First().Split('');
foreach (var header in headers)
data.Columns.Add(header);
var records = reader.Skip(1);
foreach (var record in records)
data.Rows.Add(record.Split(''));
}