Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Sort in fields date and columns.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Sort in fields date and columns.
# 1  
Old 03-25-2013
Sort in fields date and columns.
Hi colleagues,
I have this output, i need sort for 7th and 8th columns, the column 7th is date mm/dd/yyyy format and column 8th is time hh:mm:ss.number

PRUEBA 1263 0007 1 0 7131292 03/25/2013 16:43:04.159976 PROCESS
PRUEBA1 666 0146 1 0 11600064 03/25/2013 20:35:36.360453 PROCESS
PRUEBA 1232 0002 1 0 6602856 03/21/2013 10:34:04.043798 PROCESS
PRUEBA 1230 0002 1 0 9531456 03/21/2013 10:34:04.012895 PROCESS
PRUEBA 1228 0002 1 0 1769492 03/21/2013 10:34:04.012897 PROCESS
PRUEBA 1191 1270 1 0 5374148 03/25/2013 20:38:30.262300 PROCESS
PRUEBA 1186 0022 1 0 1515770 03/21/2013 10:34:04.214680 PROCESS
PRUEBA 1184 0022 1 0 9023516 03/21/2013 10:34:02.250458 PROCESS
PRUEBA 719 0033 1 0 1007752 03/25/2013 20:35:33.049410 PROCESS
PRUEBA 1142 0007 1 0 11038858 03/24/2013 03:07:52.129286 PROCESS
PRUEBA 1135 0022 1 0 8429658 03/21/2013 10:34:01.686071 PROCESS
PRUEBA 1128 0022 1 0 7278834 03/21/2013 10:34:03.878008 PROCESS
PRUEBA 901 0027 1 0 15548564 03/24/2013 03:08:40.213620 PROCESS
PRUEBA 899 0022 1 0 5456014 03/21/2013 10:33:00.883023 PROCESS
PRUEBA 1218 0023 1 0 15687680 03/24/2013 03:09:57.445248 PROCESS
PRUEBA 1208 1263 1 0 2564242 03/25/2013 20:34:48.322591 PROCESS
PRUEBA 1182 0002 1 0 15323318 03/21/2013 10:34:02.108932 PROCESS
PRUEBA 1179 0002 1 0 6193256 03/21/2013 10:34:02.086872 PROCESS
PRUEBA 1178 0022 1 0 1687770 03/21/2013 10:34:04.139296 PROCESS
PRUEBA 1175 0022 1 0 11354354 03/21/2013 10:34:04.096087 PROCESS
PRUEBA 1172 0022 1 0 15192186 03/21/2013 10:34:02.077381 PROCESS
PRUEBA 1169 0022 1 0 962692 03/21/2013 10:34:02.064175 PROCESS
PRUEBA 1167 1391 1 0 14794986 03/25/2013 20:33:41.071634 PROCESS

The output will be show in this form.
PRUEBA 1191 1270 1 0 5374148 03/25/2013 20:38:30.262300 PROCESS
PRUEBA1 666 0146 1 0 11600064 03/25/2013 20:35:36.360453 PROCESS
PRUEBA 719 0033 1 0 1007752 03/25/2013 20:35:33.049410 PROCESS
PRUEBA 1208 1263 1 0 2564242 03/25/2013 20:34:48.322591 PROCESS
PRUEBA 1167 1391 1 0 14794986 03/25/2013 20:33:41.071634 PROCESS
PRUEBA 1263 0007 1 0 7131292 03/25/2013 16:43:04.159976 PROCESS
PRUEBA 1218 0023 1 0 15687680 03/24/2013 03:09:57.445248 PROCESS
PRUEBA 901 0027 1 0 15548564 03/24/2013 03:08:40.213620 PROCESS
PRUEBA 1142 0007 1 0 11038858 03/24/2013 03:07:52.129286 PROCESS
PRUEBA 1186 0022 1 0 1515770 03/21/2013 10:34:04.214680 PROCESS
PRUEBA 1128 0022 1 0 7278834 03/21/2013 10:34:03.878008 PROCESS
PRUEBA 1184 0022 1 0 9023516 03/21/2013 10:34:02.250458 PROCESS
PRUEBA 1135 0022 1 0 8429658 03/21/2013 10:34:01.686071 PROCESS

thank you for advanced.
# 2  
Old 03-25-2013
I don't understand why your sorted output doesn't contain all of the lines in your unsorted input, but if all you want is to have your data sorted in decreasing order with year, month, day, and time as your sort keys, the following sort command:
Code:
sort -br -k7.7,7 -k7.1,7.2 -k7.4,7.5 -k8,8 -o output input

will put the following data in the file named output:
Code:
PRUEBA 1191 1270 1 0 5374148 03/25/2013 20:38:30.262300 PROCESS
PRUEBA1 666 0146 1 0 11600064 03/25/2013 20:35:36.360453 PROCESS
PRUEBA 719 0033 1 0 1007752 03/25/2013 20:35:33.049410 PROCESS
PRUEBA 1208 1263 1 0 2564242 03/25/2013 20:34:48.322591 PROCESS
PRUEBA 1167 1391 1 0 14794986 03/25/2013 20:33:41.071634 PROCESS
PRUEBA 1263 0007 1 0 7131292 03/25/2013 16:43:04.159976 PROCESS
PRUEBA 1218 0023 1 0 15687680 03/24/2013 03:09:57.445248 PROCESS
PRUEBA 901 0027 1 0 15548564 03/24/2013 03:08:40.213620 PROCESS
PRUEBA 1142 0007 1 0 11038858 03/24/2013 03:07:52.129286 PROCESS
PRUEBA 1186 0022 1 0 1515770 03/21/2013 10:34:04.214680 PROCESS
PRUEBA 1178 0022 1 0 1687770 03/21/2013 10:34:04.139296 PROCESS
PRUEBA 1175 0022 1 0 11354354 03/21/2013 10:34:04.096087 PROCESS
PRUEBA 1232 0002 1 0 6602856 03/21/2013 10:34:04.043798 PROCESS
PRUEBA 1228 0002 1 0 1769492 03/21/2013 10:34:04.012897 PROCESS
PRUEBA 1230 0002 1 0 9531456 03/21/2013 10:34:04.012895 PROCESS
PRUEBA 1128 0022 1 0 7278834 03/21/2013 10:34:03.878008 PROCESS
PRUEBA 1184 0022 1 0 9023516 03/21/2013 10:34:02.250458 PROCESS
PRUEBA 1182 0002 1 0 15323318 03/21/2013 10:34:02.108932 PROCESS
PRUEBA 1179 0002 1 0 6193256 03/21/2013 10:34:02.086872 PROCESS
PRUEBA 1172 0022 1 0 15192186 03/21/2013 10:34:02.077381 PROCESS
PRUEBA 1169 0022 1 0 962692 03/21/2013 10:34:02.064175 PROCESS
PRUEBA 1135 0022 1 0 8429658 03/21/2013 10:34:01.686071 PROCESS
PRUEBA 899 0022 1 0 5456014 03/21/2013 10:33:00.883023 PROCESS

if the data you showed in the first message in this thread is contained in the file named input.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat... (9 Replies)
Discussion started by: newstart
9 Replies

2. Shell Programming and Scripting

Sort on first fields only

Please advice in this. Input file 100,vvvt 201,unb 100,sos 301,abc 99,gang desired output 99,gang 100,vvvt 100,sos 201,unb 301,abc Means if first fields are same ( here 100) the do not sort. (4 Replies)
Discussion started by: theshashi
4 Replies

3. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

4. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

5. Shell Programming and Scripting

doing a sort on first two fields

hi, i'm having a file stg_ff.txt which contains 10 fields,which contains millions of records i need to cat the first 10 rows in the file after doing a sorting on the first two fields i n the file. can any body help me on this. regards Angel (4 Replies)
Discussion started by: angel12345
4 Replies

6. UNIX for Dummies Questions & Answers

Sort on first two fields -only-

Hey, I have a file i want to sort. It contains these kind of lines: FirstName LastName buyID buyType Eg: John Doe 22 Car Jane Simpson 4 Headset John Doe 11 Telephone Now if I use the sort command on it cat purchases.txt | sort -k1,1 -k2,2 it would also sort the third and 4th field:... (4 Replies)
Discussion started by: ce3c
4 Replies

7. UNIX for Dummies Questions & Answers

sort on three fields

Hi I would like to sort a csv file. It has 50 fields and approx 1400000 lines. I want to sort by three columns as follows. Say sort on coulmn 5, if entries are equal sort on column 3 if this is also equal sort on column 6. It seems that this is possible for 5 then 3 i.e. sort -t "," -k 5,5 -k... (1 Reply)
Discussion started by: turquoise_man
1 Replies

8. Shell Programming and Scripting

Sort two columns in a field, one of them being a date

Hi, I have a set of columns in a csv file, my first row being an integer and 2nd being a date. I want to first sort it using the first column and then by the second. for e.g. i have , 1234,09/05/2009,hi 5678,01/01/2008,hi 1234,11/03/2006,hello 5678,28/07/2010,hello i tried this... (5 Replies)
Discussion started by: sweta_doshi
5 Replies

9. Shell Programming and Scripting

sort on fields

Hi I have following fixed width file and I have to sort on 2 fields ABC 111222333002555 77788 ABC 111222333004555 77788 ABC 111222333001555 77788 ABC 111222333003555 77788 ABC 111222333005555 77788 one is from field1 to field 3 "ABC" and another is on 14 to 16 "002" (based on first... (1 Reply)
Discussion started by: mgirinath
1 Replies

10. Shell Programming and Scripting

sort fields

I have a large csv file that looks like this: 14 ,M0081,+000000001,200302,+00000100500, 14 ,M0081,+000000004,200301,+00000100500, 14 ,M0081,+000000005,200305,+00000100500, 14 ,M0081,+000000000,200205,+00000100500, 14 ,M0081,+000000008,200204,+00000100500, ... (2 Replies)
Discussion started by: edog
2 Replies
Login or Register to Ask a Question