Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Get last date from file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get last date from file
# 1  
Old 04-10-2012
Get last date from file
Hi All

I've a file which has date fields and i'm trying to get the last date from the file.

I tried sort option sort -k9 login.txt to get the files sorted based on the user

Code:
[Mar 20, 2012 2:45:18 PM]: Saved the user test1 to Planning
[Mar 20, 2012 2:53:46 PM]: Saved the user test1 to Planning
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[Mar 14, 2012 2:56:48 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:57:04 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning

The expected output is

Code:
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning

After this i tried the uniq -f1 option but it didn't give the last date line.

Can someone help me with this?
Last edited by Celvin VK; 04-10-2012 at 05:31 AM.. Reason: missed a step
# 2  
Old 04-10-2012
I tried in this way, and I got the expected results.
It is basic but it is working Smilie

PHP Code:
[user@server tempo]$ cat tot.txt
[Mar 20, 2012 2:45:18 PM]: Saved the user test1 to Planning
[Mar 20, 2012 2:53:46 PM]: Saved the user test1 to Planning
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[Mar 14, 2012 2:56:48 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:57:04 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning
[user@server tempo]$ cat tot.txt | sort -n
[Mar 14, 2012 2:56:48 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:57:04 AM]: Saved the user test2 to Planning
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning
[Mar 20, 2012 2:45:18 PM]: Saved the user test1 to Planning
[Mar 20, 2012 2:53:46 PM]: Saved the user test1 to Planning
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[user@server tempo]$ cat tot.txt | sort -n | grep test1
[Mar 20, 2012 2:45:18 PM]: Saved the user test1 to Planning
[Mar 20, 2012 2:53:46 PM]: Saved the user test1 to Planning
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[user@server tempo]$ cat tot.txt | sort -n | grep test1 | tail -1
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[user@server tempo]$ cat tot.txt | sort -n | grep test2 | tail -1
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning
[user@server tempo]$ 
# 3  
Old 04-10-2012
Hi Hammadi dali

Thank you for your help, but i can't grep on user names, because that is a dynamic field and I won't be knowing all the users.
# 4  
Old 04-10-2012
Code:
$ awk '{a[$9]=$0;next}END{for (i in a){print a[i]}}' input.txt
[Mar 22, 2012 12:25:16 PM]: Saved the user test1 to Planning
[Mar 14, 2012 2:59:03 AM]: Saved the user test2 to Planning

# 5  
Old 04-10-2012
Try:
Code:
sed -n '1!G;h;$p' login.txt | sort -uk9,9

or
Code:
tac login.txt | sort -uk9,9

This User Gave Thanks to Scrutinizer For This Post:
Celvin VK
# 6  
Old 04-10-2012
Hi

Thank you Scrutinizer and itkamaraj for your help.

I tried Scrutinizer's solution and it worked.Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

“sed” replace date in text file with current date

We want to call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below: abc.txt ------------------ Code: line1 line2 line3 $$EDWS_DATE_INSERT=08-27-2019 line4 $$EDWS_PREV_DATE_INSERT=08-26-2019 I am trying to write a... (3 Replies)
Discussion started by: pradeepp
3 Replies

2. Shell Programming and Scripting

Script to determine Date,TotalFile,total size of file based on date

I have file listed like below -rw-r--r--+ 1 test test 17M Nov 26 14:43 test1.gz -rw-r--r--+ 1 test test 0 Nov 26 14:44 test2.gz -rw-r--r--+ 1 test test 0 Nov 27 10:41 test3.gz -rw-r--r--+ 1 test test 244K Nov 27 10:41 test4.gz -rw-r--r--+ 1 test test 17M Nov 27 10:41 test5.gz I... (5 Replies)
Discussion started by: krish2014
5 Replies

3. UNIX for Dummies Questions & Answers

How to pick the latest file with date as one among the file name.( not exactly present date.)?

i have files like 1)20131112_abc_01.csv and 2)20131113_abc_01.csv and 3)20131113_abc_02.csv when i try to fetch the file in the next day. it shud pick the third file.. plz help me.. and i use `date +"%Y%m%d"` command to fetch..it fetches the current date... (2 Replies)
Discussion started by: applepie
2 Replies

4. Shell Programming and Scripting

Searching for unknown date inside the file and replace to new date

Hello, Iam a newbies to Shell scripting. Iam trying to replace the date inside the file to new date. is there anyway that we can just use the pattern to search as "..." I have many files want to replace with the same date, and each file contains different date. Thanks for your help. ... (2 Replies)
Discussion started by: Daro
2 Replies

5. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

6. Shell Programming and Scripting

ksh compare dates INSIDE a file (ie date A is > date B)

In KSH, I am pasting 2 almost identical files together and each one has a date and time on each line. I need to determine if the first instance of the date/time is greater than the 2nd instance of the date/time. If the first instance is greater, I just need to echo that line. I thought I would... (4 Replies)
Discussion started by: right_coaster
4 Replies

7. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

8. Shell Programming and Scripting

finding the previous day date and creating a file with date

Hi guys, I had a scenario... 1. I had to get the previous days date in yyyymmdd format 2. i had to create a file with Date inthe format yyyymmdd.txt format both are different thanks guys in advance.. (4 Replies)
Discussion started by: apple2685
4 Replies

9. UNIX for Dummies Questions & Answers

Move A File With Same Date,don't Change The Desitination Dir Date

Assume, I created one file three years back and I like to move the file to some other directory with the old date (Creation date)? Is it possible? Explain? (1 Reply)
Discussion started by: jee.ku2
1 Replies

10. UNIX for Dummies Questions & Answers

Changing Creation Date to a Prespecified Date of a File In Unix

Dear Expert, Is there a command to do that in Unix? In such a way that we don't need to actually "write" or modified the content. -- monkfan (4 Replies)
Discussion started by: monkfan
4 Replies
Login or Register to Ask a Question