Inside of my file i have:
2,Sam,500.00
6,Mike,400.00
8,Robert,156.00
3,Steve,100.85
9,Anderson,234.90
Order: ID, Name, Salary.
I am working on a CSV parser using C# TextFieldParser.
using (TextFieldParser parser = new TextFieldParser(path))
{
parser.TextFieldType = FieldType.Delimited;
And i use a Delimiter by comma
parser.SetDelimiters(",");
bool firstLine = true;
while (!parser.EndOfData)
{
string[] fields = parser.ReadFields();
if (firstLine)
{
foreach (var val in fields)
{
dt.Columns.Add(val);
}
firstLine = false;
continue;
}
dt.Rows.Add(fields);
How can i Sort the Data inside? Using Linq without using the function Split
var people = from line in File.ReadLines(path)
let parts = line.Split(delimiter)
select new Person {
Id = Int32.Parse(parts[0]),
Name = parts[1],
Salary = Decimal.Parse(parts[2])
};
Many Thanks