CSV files, VB.net

[paul_61]

I work in VB.net only. I cal read an entire file in one statement, sort it with another statement and write it bacl in another. Three statements to sort a csv file! This is aswome, but I wan to know how to sort the file on different columns. Here is my code,

 Dim codes(), Saveline As String
        '
        'Read/Write file data
        '
        codes = File.ReadAllLines(FileName)
        '
        'Save sorted copy
        '
        Saveline = codes(0)
        codes(0) = ""
        Array.Sort(codes)
        codes(0) = Saveline
        '
        File.WriteAllLines(FileName, codes)

What I want to do is use array.sort(codes,2)
where the 2 is column 2 or any other column. Obviously this doesnt work or I wouldn't be here. Is there a way to do this with the Array call?

Thanks!

[Reverend Jim]

I don't know about the array method but you might read it into a ListView then see here for how to do a custom sort on any column.

[tinstaafl]

Another suggestion would be a DataGridView which has the ability to sort the data by any column. With a DataTable as the data source you have the option to save/read the data to/from xml formatted text file.

[paul_61]

Thank you for all your answers! They helped.