order date

[JATAIDE]

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

 

[mc73]

One simple way is to set dates in the format yyyymmdd. This way you can easily sort using a list.

 

[JATAIDE]

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?

 

[mc73]

You need to perform multiple-column sorting?

 

[JATAIDE]

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:

 

[mc73]

Are these big files? But anyway, I think you should go for creating a table at a database and perform a query for sorting.