|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| comp.unix.shell Using and programming the Unix shell. |
 |
|
|
LinkBack | Outils de la discussion |
28/08/2007, 07h39
|
#1 |
Messages: n/a
Hébergeur: |
How to sort time
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 |
|
|
28/08/2007, 10h14
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: How to sort time
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 |
|
|
|
29/08/2007, 01h55
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: How to sort time
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: > > > > > > > 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- - > > - - Thank. It works. |
|
|
|
| Outils de la discussion | |
|
|
