Sorting csv file

Question

I have e csv file wich I need to sort. The file looks like:

 ID Name Surname Age Salary
 1  John Asben   33  1000
 2  Adam Smith   22  1200
 3  Amanda J     22  2000
 4  George Villis 36  2300

My code read data from csv file sorts them and writes to another csv file, but when it reads and writes the data after sorting, it writes just data not the title. Is there any solution to read just data not the title and to write the sorted data With title(ID Name Surnae Age Salary) to another file.

The cole looks like

private void buttonAlterSave_Click(object sender, EventArgs e)
        {
            var sorted =
    File.ReadLines(@"C:\Users\data.csv")
        .Select(line => new
        {
            SortKey = Int32.Parse(line.Split(',')[3]),
            Line = line
        })
        .OrderBy(x => x.SortKey)
        .Select(x => x.Line);
            File.WriteAllLines(@"C:\Users\sorteddata.csv", sorted);
        }

Tim Schmelter · Accepted Answer · 2013-06-02 00:05:25Z

5

Use Skip to remove the header line for sorting. Use Take + Concat to put the header and the sorted data together again.

string[] lines = File.ReadAllLines(path);
var data = lines.Skip(1);
var sorted = data.Select(line => new
             {
                SortKey = Int32.Parse(line.Split(',')[3]),
                Line = line
             })
            .OrderBy(x => x.SortKey)
            .Select(x => x.Line);
File.WriteAllLines(@"C:\Users\sorteddata.csv", lines.Take(1).Concat(sorted));

answered Jun 2, 2013 at 0:05

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jeff Mercado Over a year ago

Might as well sort it in place using Array.Sort(). Or if a list, List.Sort().

bali katravella Over a year ago

@Tim Schmelter Thank you it was perfect solution

Collectives™ on Stack Overflow

Sorting csv file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related