Okay, following my disconnect recordset posting, here is the code that I created to read CSV files to a disconnect recordset. You can then use sort on the records and manipulate the data as you like.
One thing to note, the CSV file should have quoted fields. The reason is that if you don’t quote all the fields items, some of contents of the field may contain comma (“,”), such as “Wong, Kelvin” and without this quotes, the comma may be interpreted as a delimiter in the script. By quoting every field it also makes the logic easier and more consistent.
This is one of the reasons why I almost always delimit my files with tilde (~), instead of other more common delimiters like comma or spaces.
Download code here: DisconnectRecordSet.vbs