If you mean a text file containing comma separated variables, you could import the file into something like excel or I guess you could read the file using the filesystem object and then use the split function.
There's probably a better way.
For an easy to use test automation framework, checkout my website:
Set objExcel = CreateObject("Excel.Application")
' Open csv file
Set objWorkbook = objExcel.Workbooks.Open ("C:\Scripts\MySpreadsheet.csv")
Set objWorksheet = objWorkbook.Worksheets(1)
' Select all rows
Set objRange = objWorksheet.UsedRange
'Sort according to the A column
Set objRange2 = objExcel.Range("A1")
In my application there are around 15000 records.Sorting (Descending) working fine for excel but it is taking around 30 mins to compare with other excel. In .CSV Comparing with other CSV is taking less time. That's why iam working on Descending .CSV then comparing with other .CSV file. Please let me know if you have any idea about this.
How are you comparing them? The sort function provided above by bpolitzer seems to work just fine, though i added lines:
objExcel.DisplayAlerts = False
Set objExcel = nothing
(I removed the SystemUtil statement)
A good rule of thumb is to never measure with your thumb.