order date

JATAIDE

Member
Licensed User
Longtime User
My program has a csv file that includes a date field. I wanted to sort dates in ascending order if necessary to pass the data to another file after processing. I have tried to find a way. I found no example that could help me. Someone can give me an idea. I've tried removing the days to an array and sorts them, I can do this, but as another step information? thank you
 

Attachments

  • Screenshot_2013-01-20-22-32-24.jpg
    Screenshot_2013-01-20-22-32-24.jpg
    32.4 KB · Views: 137

mc73

Well-Known Member
Licensed User
Longtime User
One simple way is to set dates in the format yyyymmdd. This way you can easily sort using a list.
 
Upvote 0

JATAIDE

Member
Licensed User
Longtime User
Thank you.
The problem may not be the only date format, but also in the remaining information. What do you think to pass all the information to a database and then run a sql command? It will be the easiest way?
 
Upvote 0

JATAIDE

Member
Licensed User
Longtime User
yes, each file has about 9 or 10 columns, the first contains the date. Now I have to order the rows and columns by their date. As I put the file attachment that has an image of the contents of the text file.

thank you :BangHead:
 
Upvote 0

mc73

Well-Known Member
Licensed User
Longtime User
Are these big files? But anyway, I think you should go for creating a table at a database and perform a query for sorting.
 
Upvote 0
Top