How to catch date and time from log files?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to catch date and time from log files?
# 8  
Old 06-15-2011
Hi michaelrozar17,


Thanks for helping me,

as i have mentioned in last post plz help me to disply the output as shown in below:

date:2011-05-09

Time:
17:14:59
17:29:53
17:45:14
.
.
.
.

Regards,
Priyanka


---------- Post updated at 01:22 PM ---------- Previous update was at 01:22 PM ----------

my log file contain only single date Eg:2011-05-09

which does not change.

Only the time is going to update contionuously ...


so i want an output of time should be like this

Time:
17:14:59
17:29:53
17:45:14
.
.
.
.


updated time should display on each separate line
# 9  
Old 06-15-2011
Code:
 
nawk -F"\|" '{ if (NR==1){ printf ("Date :%s\nTime:%s\n",substr($15,1,10),substr($15,12,8)) } else {print substr($15,12,8)}}' /tmp/myfile

# 10  
Old 06-15-2011
Its the same sed as in post# 4 except, the highlighted ones. If you need the output in a single command then you would need to resort to awk solutions..
Code:
sed -n 's/.*|\([0-9-]*\) .*/Date:\1/p' inputfile | uniq
sed -n 's/.*|[^|]* \([0-9:]*\).*/\1/p' inputfile

# 11  
Old 06-16-2011
i am new to shellscript.can u plz tell me awk function here...
# 12  
Old 06-16-2011
did u try my awk ?

Code:
nawk -F"\|" '{ if (NR==1){ printf ("Date :%s\nTime:%s\n",substr($15,1,10),substr($15,12,8)) } else {print substr($15,12,8)}}' /tmp/myfile

nawk is advance than awk

but the above code will work for awk also. just replace nawk with awk
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing files by date/time

I am trying to compare identically named files in different directories and replace a file only with a newer version. Is there a way of doing this? TIA (4 Replies)
Discussion started by: wbport
4 Replies

2. Shell Programming and Scripting

Files with date and time stamp

Hi Folks, Need a clarification on files with date and time stamp. Here is my requirement. There is a file created everyday with the following format "file.txt.YYYYMMDDHHMMSS". Now i need to check for this file and if it is available then i need to do some task to the file. I tried... (6 Replies)
Discussion started by: jayadanabalan
6 Replies

3. Shell Programming and Scripting

Extracting log files based on date and time.

Hi All, i have some log files generated in a folder daily with the format abc.def.20130306.100001 ghi.jkl.20130306.100203 abc.def.20130305.100001 ghi.jkl.20130305.100203 the format is the date followed by time . all i want is to get the files that are generated for todays... (3 Replies)
Discussion started by: mahesh300182
3 Replies

4. Shell Programming and Scripting

Delete log files content older than 30 days and append the lastest date log file date

To delete log files content older than 30 days and append the lastest date log file date in the respective logs I want to write a shell script that deletes all log files content older than 30 days and append the lastest log file date in the respective logs This is my script cd... (2 Replies)
Discussion started by: sreekumarhari
2 Replies

5. Shell Programming and Scripting

How can view log messages between two time frame from /var/log/message or any type of log files

How can view log messages between two time frame from /var/log/message or any type of log files. when logfiles are very big and especially many messages with in few minutes, I would like to display log messages between 5 minute interval. Could you pls give me the command? (1 Reply)
Discussion started by: johnveslin
1 Replies

6. UNIX for Dummies Questions & Answers

Adding date and time to a log file

Morning all Im hoping you can help me. We have a nice new oracle server :( and are needing to move some files around for EDI and BACS. The server runs windows but has an app called MKS toolkit installed which give unix commands. (Needed for the oracle stuff) I have had a go using dos commands... (2 Replies)
Discussion started by: ltodd2
2 Replies

7. Shell Programming and Scripting

Processing a log file based on date/time input and the date/time on the log file

Hi, I'm trying to accomplish the following and would like some suggestions or possible bash script examples that may work I have a directory that has a list of log files that's periodically dumped from a script that is crontab that are rotated 4 generations. There will be a time stamp that is... (4 Replies)
Discussion started by: primp
4 Replies

8. UNIX for Dummies Questions & Answers

List files with date and time stamps only

Hi there, I'm using terminal on mac and using the ls -l command to list all the files in a directory. However, I only want to display the date and time stamp of each file rather than permissions, owner, group etc... Is this possible? Many thanks in advance Dave (2 Replies)
Discussion started by: davewg
2 Replies

9. Shell Programming and Scripting

Date and time log file

Hi, I wrote a small perl script in unix that searches in a file and saves some information in a separate file. Since this is a log file, I would like to have the date added to file name. I have no idea where to start. output: log_010907.txt thanks ken (8 Replies)
Discussion started by: captoro
8 Replies

10. UNIX for Dummies Questions & Answers

Comparing files named by date/time

I've looked at several of the previous posts and can't seem to find any that pertain to my problem, I'd appreciate some help if possible. I have a directory with numerous logs of various names all named by heading and date ie. dog.20050529.log dog.20050530.log ... (2 Replies)
Discussion started by: gillr
2 Replies
Login or Register to Ask a Question