|
Home > Archive > Unix Shell > August 2007 > How to sort time
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| moonhk 2007-08-28, 7:21 am |
| Hi all
My file using "," as delimiter. How to sort the time(hh:ss) in order ?
# cat sort_time.txt
pmshare,pts/4,Aug 28,05:29,9:03,2269322
pmshare,pts/49,Aug 28,05:29,11:03,2269322
pmshare,pts/49,Aug 28,05:29,1:03,2269322
# cat sort_time.txt | sort -t , -r -k 5
pmshare,pts/4,Aug 28,05:29,9:03,2269322
pmshare,pts/49,Aug 28,05:29,1:03,2269322
pmshare,pts/49,Aug 28,05:29,11:03,2269322
#
should be
pmshare,pts/49,Aug 28,05:29,11:03,2269322
pmshare,pts/4,Aug 28,05:29,9:03,2269322
pmshare,pts/49,Aug 28,05:29,1:03,2269322
| |
| Jeroen van Nieuwenhuizen 2007-08-28, 7:21 am |
| On Mon, 27 Aug 2007 23:39:36 -0700
somebody claiming to be moonhk wrote:
> Hi all
>
> My file using "," as delimiter. How to sort the time(hh:ss) in order ?
>
>
> # cat sort_time.txt
> pmshare,pts/4,Aug 28,05:29,9:03,2269322
> pmshare,pts/49,Aug 28,05:29,11:03,2269322
> pmshare,pts/49,Aug 28,05:29,1:03,2269322
>
> # cat sort_time.txt | sort -t , -r -k 5
> pmshare,pts/4,Aug 28,05:29,9:03,2269322
> pmshare,pts/49,Aug 28,05:29,1:03,2269322
> pmshare,pts/49,Aug 28,05:29,11:03,2269322
> #
>
> should be
> pmshare,pts/49,Aug 28,05:29,11:03,2269322
> pmshare,pts/4,Aug 28,05:29,9:03,2269322
> pmshare,pts/49,Aug 28,05:29,1:03,2269322
sort -t , -r -k 5 -n sort_time.txt
Kind regards,
Jeroen.
--
ir. Jeroen van Nieuwenhuizen
Email: jnieuwen [at] jeroen [dot] se
I know I'm not perfect but I can smile
| |
| moonhk 2007-08-29, 1:15 am |
| On 8 28 , 5 14 , Jeroen van Nieuwenhuizen
<devn...@NOSPAMexperimental.net> wrote:
> On Mon, 27 Aug 2007 23:39:36 -0700
> somebody claiming to be moonhk wrote:
>
>
>
>
>
>
>
>
>
>
> sort -t , -r -k 5 -n sort_time.txt
>
> Kind regards,
>
> Jeroen.
>
> --
> ir. Jeroen van Nieuwenhuizen
> Email: jnieuwen [at] jeroen [dot] se
> I know I'm not perfect but I can smile- -
>
> - -
Thank. It works.
|
|
|
|
|