How to script to find the newer date in a text file?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to script to find the newer date in a text file?
# 1  
Old 08-10-2009
Bug How to script to find the newer date in a text file?

Hi,
I have a text file, foo.txt, it looks something like below. In the file there is a line that gives the date in the form of: Mon Jun 15 11:09:31 2008. I need to find which date is the newest and then store certain details of that list data to another file. So, in this sample text file, I need the data from add, mob and tele from List #1 into another file called foo1.txt because List # 1 is the newest and those three attributes are the only ones I ever need.


foo.txt:
Code:
List  #            Name
-----           ------------------
4                george
6                george
5                george
1                george

List  #: 4
Name:        blah1
Tele:           blah2
Mob:          blah3
Add:          blah4
Ext. 1:       blah5
Ext. 2:       blah6
Ext. 3:       blah7
Date:         Mon Jun 15 11:09:31 2008

List #: 6
Name:        blah1
Tele:           blah2
Mob:          blah3
Add:          blah4
Ext. 1:       blah5
Ext. 2:       blah6
Ext. 3:       blah7
Date:         Mon Jun 15 11:10:31 2008

List #: 5
Name:        blah1
Tele:           blah2
Mob:          blah3
Add:          blah4
Ext. 1:       blah5
Ext. 2:       blah6
Ext. 3:       blah7
Date:         Mon Jun 15 11:11:31 2008

List #: 1
Name:        blah1
Tele:           blah2
Mob:          blah3
Add:          blah4
Ext. 1:       blah5
Ext. 2:       blah6
Ext. 3:       blah7
Date:         Mon Jun 15 10:09:31 2008

# 2  
Old 08-10-2009
You could convert the dates to seconds and see which one is largest and then go back and grab the appropriate data you want.

Code:
date -d "Mon Jun 15 10:09:31 2008" +%s

# 3  
Old 08-10-2009
How would I grab those dates to perform that?
And how would I then grab that data from that correct List #?
# 4  
Old 08-10-2009
grep or egrep would probably be a good start.
# 5  
Old 08-10-2009
Understood, looking for some syntax help.
# 6  
Old 08-10-2009
Code:
egrep "Tele|Mob|Add|Date" foo.txt | cut -d: -f2-

# 7  
Old 08-10-2009
Awesome, thank you for your help.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl script, replace file with newer file

Hello, Can you please help me one this: I have two servers: Server A and server B. Every day on 03.00AM in only one on these two servers (randomly)is generated one file, lets say file.txt. I want to copy this file also to the other server. I want to create a perl script that does... (2 Replies)
Discussion started by: arrals_vl
2 Replies

2. Shell Programming and Scripting

Need a unix script to convert date into Julian format in a text file

The 6th & 7th column of the text files represents date & time. I need this to be converted in julian format using command "date +%s -d <date>". I know the command, but dont know how to use it on the script 0 dbclstr-b IXT_Web Memphis_Prod_SQL_Full Memphis-Prod-SQL-Full-Application-Backup... (4 Replies)
Discussion started by: ajiwww
4 Replies

3. UNIX for Dummies Questions & Answers

Find files newer than x days

We had an arrant rsync run and started copying over new files from one system to another. Although this is what we will want to do at some point, for now, we want to maintain the system as it was a few days ago. I am looking for a script that will find files that are newer than x days. ... (5 Replies)
Discussion started by: Leyva62
5 Replies

4. Shell Programming and Scripting

how to find a file then overwrite with a newer version

This should be a simple script, but can't find one with google search. I just need to find the file that is in many directories, then overwrite that file with a newer version i.e. find file.jar then overwrite with /root/file.jar All I get in searches is substitute text with new test inside... (1 Reply)
Discussion started by: haircat
1 Replies

5. Shell Programming and Scripting

Problems with find's -newer Flag

I am writing a script that looks in a reports directory, copies a specified script to a working folder, copies some data files into the working folder, runs the report, zips the new files, then uploads them. Right now to determine what files to zip (as I don't know how many report files there... (6 Replies)
Discussion started by: droppedonjapan
6 Replies

6. UNIX for Advanced & Expert Users

find -cmin or fin -newer

I am running SUSE/8 and SUSE/9 on a high end server (4 CPU, 8G RAM etc) I have a huge directory structure with over 4million files in it. I have find the files that are modified (created, modified, renamed etc etc) in the last 10 minutes periodically. I have tried "find -cmin -10" and "find... (2 Replies)
Discussion started by: xxxyyyy
2 Replies

7. Solaris

To copy the files newer than specific date

Dear all, Can you help me in copying files newer than speciifc date Thanks in advance, Rajesh (3 Replies)
Discussion started by: RAJESHKANNA
3 Replies

8. UNIX for Advanced & Expert Users

find file with date and recursive search for a text

Hey Guyz I have a requirement something like this.. a part of file name, date of modification of that file and a text is entered as input. like Date : 080206 (MMDDYY format.) filename : hotel_rates text : Jim now the file hotel_rates.ZZZ.123 (creation date is Aug 02 2006) should be... (10 Replies)
Discussion started by: rosh0623
10 Replies

9. Shell Programming and Scripting

Problem with find ! -newer

Hi, I would like to find if a file called test.log is older than 10 min. So i wrote : #!/usr/bin/ksh FICLOG="/home/uuu/result_test.log" FIC="/home/uuu/test.log" touch -t `perl -e 'use POSIX qw(strftime); printf("%s\n",strftime("%m%d%H%M",localtime(time-3600*0.17)));'`... (3 Replies)
Discussion started by: dbfree
3 Replies

10. UNIX for Dummies Questions & Answers

Find files newer than...

Is there a way to use the find command to locate files newer than a specific date? Thanks! --Alex (4 Replies)
Discussion started by: vertigo23
4 Replies
Login or Register to Ask a Question