how to sort the Dates in array list in vb.net?

Question

i have several files named in dated format(dd/mm/yyyy) .i have to collect them and sort in arraylist ? any suggestion ...i did like this

Dim filepath As String = FileStr
Dim directoryPath As String = System.IO.Path.GetDirectoryName(filepath)
Dim arrayList As New System.Collections.ArrayList()
For Each file As String In System.IO.Directory.GetFiles(directoryPath)
 arrayList.Add(System.IO.Path.GetFileNameWithoutExtension(file))
Next
arrayList.Sort()

User999999 · Accepted Answer · 2015-06-29 07:45:09Z

2

NOTE: a file named 29/06/2015.txt is not valid on Windows. the following code has been tested using the following formats: yyyy-mm-dd,yyyy-dd-mm,...

Would the following implentation not work? This uses a List however instead of your arraylist.

Dim filepath As String = FileStr
Dim directoryPath As String = System.IO.Path.GetDirectoryName(filepath)
Dim myFileList As New List(Of String)
For Each file As String In System.IO.Directory.GetFiles(directoryPath)
    'Add only dates to the list
    If (IsDate(System.IO.Path.GetFileNameWithoutExtension(file))) Then
        myFileList.Add(System.IO.Path.GetFileNameWithoutExtension(file))
    End If
Next
myFileList.OrderByDescending(Function(x) CType(x, DateTime))

Use OrderBy Or OrderBydescending to change the direction of sorting

If the Arraylist is mandatory then you still can change the output you can easily create an ArrayList from a List as follows.

Dim arr As New ArrayList(myFileList)

edited Jun 29, 2015 at 7:45

answered Jun 29, 2015 at 7:10

User999999

2,5307 gold badges42 silver badges63 bronze badges

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

5 Comments

Satyajit Over a year ago

then what about different months ?

User999999 Over a year ago

if the format is dd/mm/yyyy then the ordering should be fine for Days-Months-Years.

User999999 Over a year ago

IsDateis just a standard framework method: msdn.microsoft.com/en-us/library/00wf8zk9(v=vs.90).aspx

User999999 Over a year ago

My bad, made a typo. Code has been altered.

Satyajit Over a year ago

Let us continue this discussion in chat.

Collectives™ on Stack Overflow

how to sort the Dates in array list in vb.net?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related