Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort array on specific column
Message
 
 
To
12/02/2004 11:09:22
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00876693
Message ID:
00876697
Views:
14
This message has been marked as the solution to the initial question of the thread.
Tracy,

Try
* Create sorting column first: Date + Time + File name
FOR i=1 TO ALEN(laDummy,1)
	laDummy[i,5] = DTOS(laDummy[i,3]) + laDummy[i,4] + laDummy[i,1]
ENDFOR
ASORT(laDummy,5,-1, 1)
browarr(@laDummy)
>If I create an array of files matching the following skeleton:
>
>
>=ADIR(laDummy,tivansdir+"\POLDATA.*")
>
>and the resulting array contains 3 files like so:
>
>ladummy[1,1] "POLDATA.001"
>ladummy[1,2] 8860
>ladummy[1,3] {02/12/2004}
>ladummy[1,4] "10:57:40"
>ladummy[1,5] ".A..."
>ladummy[2,1] "POLDATA.AL3"
>ladummy[2,2] 1008889
>ladummy[2,3] {01/15/2004}
>ladummy[2,4] " 9:09:56"
>ladummy[2,5] ".A..."
>ladummy[3,1] "POLDATA.002"
>ladummy[3,2] 8854
>ladummy[3,3] {02/12/2004}
>ladummy[3,4] "11:10:56"
>ladummy[3,5] ".A..."
>
>Now I want to sort the array (or create a new array) listing the results by datetime with the most recent file date first (or by reverse order). How would I do that? I am having no luck today with the ASORT() command...
>
>TIA,
>
>Tracy
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform