extracting data from file using time stamp


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extracting data from file using time stamp
# 1  
Old 09-22-2011
Java extracting data from file using time stamp

Hi Guys !

is it possible to extract lines from a file which satisfy a time contraint

for example program should consider two boundaries one current time and second the user define time and then extract all those line which fall into that specified time

lets say 10 (user define time) and 12 (system time)

now the program return all the line from logfile which has a time stamp between 12 and 10 hours

suppose data is like this

abc bachd 14/07/2010:11:15:30
cde babde 15/01/2011:05:30:01
bad riewie 30/12/2010:04:18:00

out file should have only first line because it is the only line that satisfy the hours constraint


Best Regards,

TJ

Last edited by ourned; 09-22-2011 at 10:02 AM..
# 2  
Old 09-22-2011
Code:
$ grep "/....:1[0-2]:" infile
abc bachd 14/07/2010:11:15:30
$


Last edited by jayan_jay; 09-23-2011 at 03:57 AM.. Reason: corrected code
This User Gave Thanks to jayan_jay For This Post:
# 3  
Old 09-22-2011
Wont that also grep 10 or 12 minutes?

egrep ":1[0-2]:..:.." infile
# 4  
Old 09-23-2011
Hi Jayan_jay !

it is working fine but can you explain how it is working so that i change it according to my requirements? and one more thing it is considering 12 hours also i want only 10th hour, 11th hour up to 11:59, how can it be generalized i mean the user input should be given at run time....



Thanks in advance

Regards,

TJ
# 5  
Old 09-23-2011
refer the link (section 4.2.2.2) .. hope that will clears .. Smilie
Examples using grep
Below the code for the current req.
Code:
$ grep "/....:1[0-1]:" infile
abc bachd 14/07/2010:11:15:30
abc bachd 14/07/2010:11:59:30
$

This User Gave Thanks to jayan_jay For This Post:
# 6  
Old 09-23-2011
Hi Jay!

thanks for your help and time

Best Regards,

TJ
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Capturing time stamp in file name

I have a file that is created via a perl script where the file is named like so: 01-07-2016_10:17:08. I am running a shell script that needs to take this file and print it. I can capture the date portion fine, but I am unsure how to capture the time stamp, since there will be a difference from what... (1 Reply)
Discussion started by: ldorsey
1 Replies

2. Shell Programming and Scripting

Check file time stamp

Hi, I need help to read file in a directory on basis of time stamp. e.g. If file access in last 2 minutes it should not be copy to remote directory. Below is my script. #!/bin/ksh DATE=`date +"%Y-%m-%d_%H%M"` SEPARATER=" " exec < out_interfaces.cfg while read source_path... (10 Replies)
Discussion started by: qamar.alam
10 Replies

3. Shell Programming and Scripting

file time stamp

Hi All, I am facing small problem. i want to print file time stamp on which date file has placed in the server. i have given some code but its not giving the year. any help appreciated. regards rajesh. (4 Replies)
Discussion started by: rajesh_pola
4 Replies

4. Shell Programming and Scripting

creating a file with time stamp

Hi guys, Here my scenario is to find the files of previous days if the previous day load had not done. for that i created a file with time stamp and this file is created after the load completes. so every dau i search for the this file with previous days time stamp. i want to create a file... (1 Reply)
Discussion started by: apple2685
1 Replies

5. Shell Programming and Scripting

Change time stamp of a file

Hi, As i know , we can change the time stamp of a file by touch command, i did change in a file and it is looking as given # ls -l abcd -rw-r--r-- 1 batsoqa sicusers 0 Feb 17 2010 abcd actually i want to see the output like this -rw-r--r-- 1 batsoqa sicusers ... (3 Replies)
Discussion started by: apskaushik
3 Replies

6. Shell Programming and Scripting

how to touch a file with prev time stamp

i want to find the files which are modified in last 30 to 120 minutes i am using "find . -mmin +30 -mmin -120 " it is giving me the error find: bad option -mmin find: path-list predicate-list can somebody help me out . Thank you (5 Replies)
Discussion started by: Prat007
5 Replies

7. Shell Programming and Scripting

change the time stamp of file

can we change the timestamp of a file to old date. -rwxrwxrwx 1 root other 330 Jul 1 16:03 abc.txt it shows creation time is 16.03 can i change it to previous time :) (2 Replies)
Discussion started by: anish19
2 Replies

8. Shell Programming and Scripting

how do i put a time stamp in a file name

i want to copy a filea.dat to a file name in the format of filea_yyyymmdd_hhmi.dat using something like DTSTAMP=$(date "+%Y%m%d"), which puts it in format filea_yyyymmdd.dat (5 Replies)
Discussion started by: jhamm
5 Replies

9. UNIX for Dummies Questions & Answers

time stamp of file create

Hi, Sounds a simple request but I also need (would like) to gather the seconds too. I'm not even sure if this is held. I would think it is, somewhere??!!?! I belive that stat would/could work but I don't do C (we'll not yet). Is there any comamnd line util I can use? SunOS. Cheers... (7 Replies)
Discussion started by: nhatch
7 Replies

10. UNIX for Dummies Questions & Answers

File date and time stamp

I have to capture the creation date and time stamp for a file. The ls command doesn't list all the required information. I need year, month, day, hour, minute and second. Any ideas... (1 Reply)
Discussion started by: Xenon
1 Replies
Login or Register to Ask a Question