Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Sort Date YYYYDDD

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sort Date YYYYDDD
# 8  
Old 10-24-2012
BARTUS11,

Thanks a lot for your correction.

The code is working perfect, but If I may what mean it ?

Code:
-k6.11,6.17 -k 6

In same time, how to execute the PERL code in shell script ? There is a condition ? Sorry for my question ...but I got a "cannot execute error".

Thanks
# 9  
Old 10-24-2012
Quote:
Originally Posted by Aswex
...
Output Needed
Code:
New File: 95106 Oct 21 TAG__SC___2000229_0.TAB
New File: 95106 Oct 21 TAG__KSM__2001229_0.TAB
New File: 95106 Oct 21 TAG__KSO__2002229_0.TAB
New File: 95106 Oct 23 TAG__KG___2007013_0.TAB
New File: 95040 Mar 29 TAG__KSM__2012023_0.TAB
New File: 95106 Oct 21 TAG__KG___2012229_0.TAB
New File: 83226 Oct 22 TAG__KSM__2012230_0.TAB
New File: 83424 Oct 22 TAG__SC___2012230_0.TAB
New File: 79530 Oct 22 TAG__KG___2012293_0.TAB
New File: 79728 Oct 22 TAG__SC___2012293_0.TAB
New File: 79530 Oct 22 TAG__KSM__2012293_0.TAB
New File: 79530 Oct 22 TAG__KSO__2012293_0.TAB

...
@OP:
In the expected output, shouldn't the line in red be the last one?
The last 4 lines have the same "yyyyddd" value, so the sorting on "yyyyddd" and then the 6th field would result in this order:

KG < KSM < KSO < SC

tyler_durden
# 10  
Old 10-24-2012
Hello,

The Input was just some lines. In fact I used the code

Code:
 sort -k6.11,6.17 -k 6

but the result is not good as expected.

Here is what I getting :

Code:
New File: 95106 Oct 23 TAG__KSM__2012292_0.TAB
New File: 79530 Oct 22 TAG__KSM__2012293_0.TAB
_+_ File: 94710 Oct 21 TAG__KSO__2012290_0.TAB
New File: 95040 Oct 20 TAG__KSO__2012291_0.TAB
New File: 95106 Oct 23 TAG__KSO__2012292_0.TAB
New File: 79530 Oct 22 TAG__KSO__2012293_0.TAB
_+_ File: 94974 Oct 21 TAG__SC___2012290_0.TAB
New File: 95040 Oct 20 TAG__SC___2012291_0.TAB
New File: 95106 Oct 23 TAG__SC___2012292_0.TAB
New File: 79728 Oct 22 TAG__SC___2012293_0.TAB

The date of file is tje most important for me, but if the order will fit :

Code:
KG < KSM < KSO < SC

that will be great.

Note :
the head of the line could be :
New File
_+_ File
_-_ File


Thanks
# 11  
Old 10-24-2012
Code:
awk -F'_|__|___' '{print $3,$0 | "sort"}' file

# 12  
Old 10-24-2012
Code:
$
$ cat f72
New File: 95106 Oct 23 TAG__KSM__2012292_0.TAB
New File: 79530 Oct 22 TAG__KSM__2012293_0.TAB
_+_ File: 94710 Oct 21 TAG__KSO__2012290_0.TAB
New File: 95040 Oct 20 TAG__KSO__2012291_0.TAB
New File: 95106 Oct 23 TAG__KSO__2012292_0.TAB
New File: 79530 Oct 22 TAG__KSO__2012293_0.TAB
_+_ File: 94974 Oct 21 TAG__SC___2012290_0.TAB
New File: 95040 Oct 20 TAG__SC___2012291_0.TAB
New File: 95106 Oct 23 TAG__SC___2012292_0.TAB
New File: 79728 Oct 22 TAG__SC___2012293_0.TAB
$
$
$ sort -k6.11 -k6 f72
_+_ File: 94710 Oct 21 TAG__KSO__2012290_0.TAB
_+_ File: 94974 Oct 21 TAG__SC___2012290_0.TAB
New File: 95040 Oct 20 TAG__KSO__2012291_0.TAB
New File: 95040 Oct 20 TAG__SC___2012291_0.TAB
New File: 95106 Oct 23 TAG__KSM__2012292_0.TAB
New File: 95106 Oct 23 TAG__KSO__2012292_0.TAB
New File: 95106 Oct 23 TAG__SC___2012292_0.TAB
New File: 79530 Oct 22 TAG__KSM__2012293_0.TAB
New File: 79530 Oct 22 TAG__KSO__2012293_0.TAB
New File: 79728 Oct 22 TAG__SC___2012293_0.TAB
$
$

tyler_durden
This User Gave Thanks to durden_tyler For This Post:
Aswex
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort by name and date

nawk '$1=="Date" {d=$(NF-2);next} $1=="Queue" {q=$NF;next} $1=="Forms"{print q, $NF, d}' OFS='|' printfile.log I have this script working. Please let me know how to sort by Queue and then Date. (4 Replies)
Discussion started by: Daniel Gate
4 Replies

2. 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

3. Shell Programming and Scripting

sort the date

Hi All, Please help me to sort the date field which is in the format 2012-02-03 16:09:37.388... Platform: Red Hat linux Thanks in advance (2 Replies)
Discussion started by: jesu
2 Replies

4. UNIX for Dummies Questions & Answers

how to combine du -h and sort by date

The problem: I have a task to give a my boss: 1. the files and directory sizes in human readable form: du -h 2. He also wants me to give him the date stamp on the files and directories. something like ls -R or sort by date Does anyone have a script that can do this efficiently (I am... (2 Replies)
Discussion started by: obology
2 Replies

5. UNIX for Dummies Questions & Answers

Sort comand for Date

Hi All, I have two questions for sorting based on date. Sample input: 2009/07/23 11:48:44|alpha 2009/07/23 11:48:44|gamme 2009/07/23 11:48:44|beta 2009/07/23 11:48:44|test 2009/07/23 11:48:44|data 2009/07/23 11:48:44|hello 2009/07/23 11:48:44|cat Output: 2009/07/23... (3 Replies)
Discussion started by: quintet
3 Replies

6. Shell Programming and Scripting

sort date issue

Hi Everyone, # cat b Sat 12 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 11:32:49 AM MYT; Sat 13 Sep 2009 10:31:49 PM MYT;a;a;a;Mon 14 Sep 2009 10:31:49 PM MYT; Sat 14 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 10:31:49 PM MYT; # sort -t';' -k5 b Sat 13 Sep 2009 10:31:49 PM... (8 Replies)
Discussion started by: jimmy_y
8 Replies

7. Shell Programming and Scripting

how to sort by the date

Hello World~ Please Help Me(BASH) input: dde,2007.8.25,891 dde,2007.8.23,356 dfe,2007.10.12,341 cba,2005.12.5,342 I wanna know how to sort by the date(2005.12.5) output: cba,2005.12.5,342 dde,2007.8.23,356 dde,2007.8.25,891 dfe,2007.10.12,341 Thanks in advance (3 Replies)
Discussion started by: lifegeek
3 Replies

8. Linux

sort files by date

Hi All, Sorry to throw this frequent question but I lost my notes on it. How do you list the files by date? I'm on red hat. Thanks in advance, itik (1 Reply)
Discussion started by: itik
1 Replies

9. UNIX for Dummies Questions & Answers

sort by date and concatenate first three

Hi: I am trying to create some script that sorts the files in a subdirectory by date and concatenates the thre most recently created files. SAy, file1 date1 file2 date2 file3 date3 file4 date4 file5 date5 file6 date6 i only want to concatenate the first three which are the most... (4 Replies)
Discussion started by: jlarios
4 Replies

10. Shell Programming and Scripting

Sort by Date

I'm looking to edit a file which contains various data including date.(ddmmyyyy) I want to sort by date and then count the number of different dates found Any ideas how to acheive this Thanks in advance. (2 Replies)
Discussion started by: Mudshark
2 Replies
Login or Register to Ask a Question