how to sort csv file with two columns in c#

Question

my csv files have 14 columns and ~800.000 lines. I must sort csv orderby 10th column thenby 3rd column. I use below code but sorts by only 10th column

            string filePath = "D:\\csv.csv";

            string[] lines = File.ReadAllLines(filePath, Encoding.Default);

            var data = lines.Skip(1);
            var sorted = data.Select(line => new
            {
                SortKey = Int32.Parse(line.Split(';')[9]),
                 Line = line

            }
            ).OrderBy(x => x.SortKey).Select(x => x.Line);
            File.WriteAllLines("D:\\sortedCsv.csv", lines.Take(1).Concat(sorted), Encoding.Default);

my csv likes

col1 ; col2 ; col3 ;......; col10; ..
abc ; fds ;123456 ;.... ;123 ; ..
def ; dsa ; 12435 ; .... 124 ; ..

Tim Schmelter · Accepted Answer · 2014-10-10 09:30:40Z

3

You have to use OrderBy(...).ThenBy(...):

var lines = File.ReadLines(filePath, Encoding.Default);
var data = lines
           .Skip(1)
           .Select(l => new{Fields = l.Split(';'), Line = l})
           .Where(x => x.Fields.Length == 14 && x.Fields[9].All(Char.IsDigit))
           .OrderBy(x => int.Parse(x.Fields[9]))
           .ThenBy(x => x.Fields[2])
           .Select(x => x.Line);
File.WriteAllLines("D:\\sortedCsv.csv", lines.Take(1).Concat(data), Encoding.Default);

Note that File.ReadLines is more efficient than File.ReadAllLines in this case.

answered Oct 10, 2014 at 9:30

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

Comments

artm · Accepted Answer · 2014-10-10 09:26:49Z

1

var sorted = data.Select(line => new
{
    SortKey = Int32.Parse(line.Split(';')[9]),
    SortKeyThenBy = Int32.Parse(line.Split(';')[2]),
    Line = line
}
).OrderBy(x => x.SortKey).ThenBy(x => x.SortKeyThenBy)

answered Oct 10, 2014 at 9:26

artm

8,5943 gold badges28 silver badges43 bronze badges

Comments

user28470 · Accepted Answer · 2014-10-10 09:26:27Z

1

you need to use thenBy after the first OrderBy

            var sorted = data.Select(line => new
            {
                SortKey = Int32.Parse(line.Split(';')[9]),
                 Line = line

            }
            ).OrderBy(x => x.SortKey).ThenBy(x => x.Line);

answered Oct 10, 2014 at 9:26

user28470

4277 silver badges17 bronze badges

Comments

shree.pat18 · Accepted Answer · 2014-10-10 09:27:02Z

1

Try this:

var sorted = data.Select(line => new
        {
            SortKey = Int32.Parse(line.Split(';')[9]),
            SortKey2 = line.Split(';')[2],
             Line = line

        }
        ).OrderBy(x => x.SortKey).ThenBy(x=>x.SortKey2).Select(x => x.Line);

Basically add your second sorting criterion and then sort in the specified order.

answered Oct 10, 2014 at 9:27

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Collectives™ on Stack Overflow

how to sort csv file with two columns in c#

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related