number could be desc instead of asc, you could simply read from the
bottom to the top.
Otherwise, I'd put them in an array or structs, find each 'block' of
account numbers, and re-insert that block upside-down into a new array.
HTH.
--Ben
Jeff Waris wrote:
> Got a real odd sorting problem here, and I am kind of stumped....
>
>
> Using CFHTTP, I generate a file on the fly that contains some user
> information. It has three fields on each line, constituting 1 record. This
> file cannot be formatted any other way. I have no control over it. (Until it
> gets to me)
>
>
> the file is formatted like this
>
>
> 11111111,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,03-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,04-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,03-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,04-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
>
>
> Field one is an account number, field two is a date and the third field is
> an associated picture(uniquely named for each line) The dates may range over
> a year or two. the file is sorted by account number then by date ascending.
> I need to sort by account number then by date DESCENDING.
>
>
> I've tried to sort descending, by treating each line as a list item using
> listsort(). It almost works. For everything under a year, the list sort is
> fine, but anything with entries over 1 year for an account I would get this:
>
> 11111111,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,01-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,03-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,04-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
>
>
> I was thinking of putting everything in array, but I don't think I will be
> able to sort them the way I want this way either. Is there a way to do this
> without database intervention? Any help would be greatly appreciated...
>
>
> Thanks!
> Jeff
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
