forum.vdsworld.com

LiquidCode

I am having a big problem and my brain hurts!

I have data and I want to sort a colum then sort by another column while keeping the first colum still sorted. In effect sorting within a sort. Does anyone have an idea or code on how to do this. Here is exactily what I want to do.

This is an entry in a log:

2531.023,02/05/2004,10:45 AM,dyost,11,Billable,B & W,Bond,30x42,1,Transportation,

There are MANY entries like this in the file. I need to sort column 1 then within that sort by column 9 then within that by 10.

Any help would be very.....well....helpfull!!

Thanks Much!

Skit3000 · Posted: Thu Feb 05, 2004 6:41 pm Post subject:

I think you should check if the first column you want to sort on, is the same as the first column of the previous item. If so, sort it on the second column as well. If not, continue to the next item...

LiquidCode · Posted: Thu Feb 05, 2004 6:46 pm Post subject:

Well, It's not that easy. I was hoping someone had already done this. I am pulling my hair out. I am on a tight deadline. Crying or Very sad

Skit3000 · Posted: Thu Feb 05, 2004 7:03 pm Post subject:

Maybe you can find a little example from another programming language, which you can convert to VDS?

jwfv · Posted: Thu Feb 05, 2004 7:14 pm Post subject:

Some time ago, I found a utility called TextTools. They are just a collection of command-line utilities for manipulating text data files. I tested them out and they were blindingly fast and seemed handy, but I never had a use for them.

In your case, you could output your list to a file with values separated by whichever character you like. Then invoke the sorting utility (which will sort by as many columns as you like) and then bring the output file back in - voila - your multiple-sorted list.

Here is the main page:

http://home.online.no/~runeberg/tt/tthome.htm

and here is the specific utility I'm talking about:

http://home.online.no/~runeberg/tt/tsort.htm

I always thought these would work very well with VDS since they both can use character-delimited data files.

Hope it is helpful -

LiquidCode · Posted: Thu Feb 05, 2004 7:22 pm Post subject:

Where do I DL it? I can't find a link. Sad

LiquidCode · Posted: Thu Feb 05, 2004 7:25 pm Post subject:

Found it! Thanks much!!

jwfv · Posted: Thu Feb 05, 2004 7:26 pm Post subject:

http://www.simtel.net/product.download.mirrors.php?id=6431

from this page, about halfway down:

http://home.online.no/~runeberg/tt/tthome.htm#intro

There also appear to be some updates to install from the page above.

jwfv · Posted: Thu Feb 05, 2004 7:27 pm Post subject:

Technically I guess I should give this URL:

http://home.online.no/~runeberg/tt/tthome.htm#download

jwfv · Posted: Thu Feb 05, 2004 7:29 pm Post subject:

Just saw your message - hope it works. Let me know if it does, I'll be interested. Might have a use for it myself sometime.

LiquidCode · Posted: Thu Feb 05, 2004 7:32 pm Post subject:

I'll let you know, cause if it doesn't, I gotta keep looking.

jwfv · Posted: Thu Feb 12, 2004 3:37 pm Post subject:

Did you ever get a chance to try this out? How did it work?

LiquidCode · Posted: Thu Feb 12, 2004 3:41 pm Post subject:

Sorry, Yes it works very nicely for my application. Thanks again.