请教一下，怎么将文件每行的时间进行排序

_lpq

,12:13:57,a,b,c
12:14:11,12:14:18,a,e,a
,12:14:02,a,e,d
12:14:13,12:16:56,a,e,v
12:17:25,12:17:32,a,d,h
12:14:02,12:14:11,a,s,u
,12:14:14,a,z,u
12:14:29,12:14:36,a,g,d


求教各位大神！
第一个逗号前面为开始的时间，如果没有则为空
第二个逗号为结束的时间，如果没有则为空


现有两个问题：
1）怎么先对开始的时间进行排序，再对结束的时间进行排序
2）假如格式是这样的呢？怎么进行排序
2016-01-14 12:14:39,2016-01-14 12:15:07,a,f,x
2016-01-14 12:13:52,2016-01-14 12:14:21,f,i,u
2016-01-14 12:13:22,2016-01-14 12:14:50,s,u,f
2016-01-14 12:14:52,2016-01-14 12:13:20,x,h,d
2016-01-14 12:13:12,2016-01-14 12:18:20,t,n,c
2016-01-14 12:14:11,2016-01-14 12:14:10,p,n,g

多谢各位大侠了~~

_lpq

然后就是修改完成的怎么输出到原文件

cao627

1. sort -t',' file
   
2. sort -k2 -t',' file

复制代码

_lpq

回复 3# cao627



谢谢~
能不能一行就搞定，然后重新输出到原文件

   

cao627

1）怎么先对开始的时间进行排序，再对结束的时间进行排序

你这句话的意思是：
1：按开始时间这一列对行进行排序得到一种结果，按结束时间这列对行进行排序得到另一种结果，即用两种不同的排序得到两种结果？ 还是
2：先按开始时间排序，如果有开始时间相同的行，这些行再按虑结束时间排序。即用一种排序得到一种结果。

如果是1的话只能是两条命令。
如果是2的话：

sort -k2 -k3  -t',' file

_lpq

回复 5# cao627


额。。。。。我写了歧义了

我的意思是先对第一列经行排序，然后相同的再第二列进行排序（就是将相同的通过第二列，安插到第二列中）


试了你的貌似不成功

   

jason680

回复 6# _lpq

easy way by sort

$ cat FILE
2016-01-14 12:14:39,2016-01-14 12:15:07,a,f,x
2016-01-14 12:13:52,2016-01-14 12:14:21,f,i,u
2016-01-14 12:13:22,2016-01-14 12:14:50,s,u,f
2016-01-14 12:14:52,2016-01-14 12:13:20,x,h,d
2016-01-14 12:13:12,2016-01-14 12:18:20,t,n,c
2016-01-14 12:14:11,2016-01-14 12:14:10,p,n,g

$ sort FILE
2016-01-14 12:13:12,2016-01-14 12:18:20,t,n,c
2016-01-14 12:13:22,2016-01-14 12:14:50,s,u,f
2016-01-14 12:13:52,2016-01-14 12:14:21,f,i,u
2016-01-14 12:14:11,2016-01-14 12:14:10,p,n,g
2016-01-14 12:14:39,2016-01-14 12:15:07,a,f,x
2016-01-14 12:14:52,2016-01-14 12:13:20,x,h,d

   

_lpq

回复 7# jason680


    谢谢大神哈！，

_lpq

回复 7# jason680
我现在遇到的问题是：


,12:13:57,a,1,c
12:14:11,12:14:18,a,3,a
,12:14:02,a,6,d
12:14:13,12:16:56,a,4,v
12:15:31,,a,2,h
12:17:25,12:17:32,a,2,h
12:14:02,12:14:11,a,4,u
,12:14:14,a,9,u
12:14:13,,i,8,s
12:14:29,12:14:36,a,3,d

就是先对第二列排 用  sort -k2 -t',' file
运行结果：

12:15:31,,a,2,h
12:14:13,,i,8,s
,12:13:57,a,1,c
,12:14:02,a,6,d
12:14:02,12:14:11,a,4,u
,12:14:14,a,9,u
12:14:11,12:14:18,a,3,a
12:14:29,12:14:36,a,3,d
12:14:13,12:16:56,a,4,v
12:17:25,12:17:32,a,2,h

我希望得到的结果是：

,12:13:57,a,1,c
,12:14:02,a,6,d
12:14:02,12:14:11,a,4,u
12:14:13,,i,8,s
,12:14:14,a,9,u
12:14:11,12:14:18,a,3,a
12:14:29,12:14:36,a,3,d
12:15:31,,a,2,h
12:14:13,12:16:56,a,4,v
12:17:25,12:17:32,a,2,h

就是先对第二列排序，然后有第二列为空值是会运行到前面，
12:15:31,,a,2,h
12:14:13,,i,8,s

我希望的是将这两列值与第一列值比较
若第一列有比   第一列值 <12:15:31 < 第一列值，则插入其中
像这样
12:14:29,12:14:36,a,3,d
12:15:31,,a,2,h
12:14:13,12:16:56,a,4,v

谢谢哈~



   

jason680

回复 9# _lpq

here you are

$ awk -F, '{if($2=="")a[$1]=$0;else b[$2]=$0}END{bt=asorti(b,bs);at=asorti(a,as);for(an=bn=1;bn<=bt;++bn){while(as[an]<bs[bn]&&an<=at)print a[as[an++]];print b[bs[bn]]}}' FILE
,12:13:57,a,1,c
,12:14:02,a,6,d
12:14:02,12:14:11,a,4,u
12:14:13,,i,8,s
,12:14:14,a,9,u
12:14:11,12:14:18,a,3,a
12:14:29,12:14:36,a,3,d
12:15:31,,a,2,h
12:14:13,12:16:56,a,4,v
12:17:25,12:17:32,a,2,h