Getting a relative timestamp from timestamp stored in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Getting a relative timestamp from timestamp stored in a file
Prev   Next
# 1  
Old 04-27-2011
Getting a relative timestamp from timestamp stored in a file

Hi,
I've a file in the following format
Code:
1999-APR-8 17:31:06     1500     3     45
1999-APR-8 17:31:15     1500     3     45
1999-APR-8 17:31:25     1500     3     45
1999-APR-8 17:31:30     1500     3     45
1999-APR-8 17:31:55     1500     3     45
1999-APR-8 17:32:06     1500     3     45

As you can see the file is sorted according to the timestamp.
I want the output in such a form that it will consist of relative timestamp in seconds for every timestamp in each line stored in a file.
For eg:
For above file the relative timestamp will be calculated w.r.t first timestamp.
Thus, the desired output would be
Code:
1999-APR-8 17:31:06     1500     3     45     0
1999-APR-8 17:31:15     1500     3     45     9
1999-APR-8 17:31:25     1500     3     45     19
1999-APR-8 17:31:30     1500     3     45     24
1999-APR-8 17:31:55     1500     3     45     49
1999-APR-8 17:32:06     1500     3     45     60

How can I deal with this?
Thanks in advance.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies

2. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

3. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies

4. Shell Programming and Scripting

To get the timestamp of a file

Hi Friends I need to get the tine stamp of a file and based on this time stamp I am doing a comparison and based on this i need to call a java jar file. I am using ksh shell and in this stat is not there. So instead of stat I am using ls -l command and using awk i am getting $6 $7 and $8... (2 Replies)
Discussion started by: Kannannair
2 Replies

5. Shell Programming and Scripting

Identifying files with a timestamp greater than a given timestamp

I need to be able to identify files with file timestamps greater than a given timestamp. I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies

6. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

7. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

8. Shell Programming and Scripting

conversion of different timestamp to standard timestamp

hi i need a scrit to convert one date format to another. for example i have three columns in a file which gets a different format, but lastly i want output with stadard timestamp as "yyyy-mm-dd hh:mm:ss" column1 column2 ... (2 Replies)
Discussion started by: dprakash
2 Replies

9. UNIX for Dummies Questions & Answers

File timestamp

Hi, Could someone please tell me how to find the last modified date (date,hours,minutes,seconds) of a file in the format YYYY-MM-DD hh:mm:ss of a file using only standard HP-UX commands? I looked for options in "ls" command but I couldn't find any options for HP-UX which gets the date details... (4 Replies)
Discussion started by: stevefox
4 Replies

10. UNIX for Dummies Questions & Answers

timestamp of file

Hi, I need to recursively find alll files generated as of today. I was able to use find and ls -l to do that but the problem i am facing is there are around 48000 subdirectories it needs to search in. Any help is appreciated. krisdhar (4 Replies)
Discussion started by: krisdhar
4 Replies
Login or Register to Ask a Question
libapache2-mod-perl2-2.0.7::docs::api::APR::IpSubnet(3pmUser Contributed Perl Documentatilibapache2-mod-perl2-2.0.7::docs::api::APR::IpSubnet(3pm)

NAME
APR::IpSubnet - Perl API for accessing APRs ip_subnet structures Synopsis use APR::IpSubnet (); my $ipsub = APR::IpSubnet->new($pool, "127.0.0.1"); $ok = $ipsub->test($sock_addr); Description "APR::IpSubnet" object represents a range of IP addresses (IPv4/IPv6). A socket connection can be matched against this range to test whether the IP it's coming from is inside or outside of this range. API
"APR::IpSubnet" provides the following functions and/or methods: "new" Create an IP subnet represenation object $ipsubnet = APR::IpSubnet->new($pool, $ip); $ipsubnet = APR::IpSubnet->new($pool, $ip, $mask_or_numbits); obj: "APR::IpSubnet" (class name) arg1: $pool ( "APR::Pool object" ) arg2: $ip ( string ) IP address in one of the two formats: IPv4 (e.g. "127.0.0.1") or IPv6 (e.g. "::1"). IPv6 addresses are accepted only if APR has the IPv6 support enabled. opt arg3: $mask_or_numbits ( string ) An optional IP mask (e.g. "255.0.0.0") or number of bits (e.g. "15"). If none provided, the default is not to mask off. ret: $ret ( "APR::IpSubnet object" ) The IP-subnet object excpt: "APR::Error" since: 2.0.00 "test" Test the IP address in the socket address object against a pre-built ip-subnet representation. $ret = $ipsub->test($sockaddr); obj: $ipsub ( "APR::IpSubnet object" ) The ip-subnet representation arg1: $sockaddr ( "APR::SockAddr object" ) The socket address to test ret: $ret ( boolean ) true if the socket address is within the subnet, false otherwise since: 2.0.00 This method is used for testing whether or not an address is within a subnet. It's used by module "mod_access" to check whether the client IP fits into the IP range, supplied by "Allow"/"Deny" directives. Example: Allow accesses only from the localhost (IPv4): use APR::IpSubnet (); use Apache2::Connection (); use Apache2::RequestRec (); my $ipsub = APR::IpSubnet->new($r->pool, "127.0.0.1"); ok $ipsub->test($r->connection->remote_addr); See Also mod_perl 2.0 documentation. Copyright mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0. Authors The mod_perl development team and numerous contributors. perl v5.14.2 2011-02-08 libapache2-mod-perl2-2.0.7::docs::api::APR::IpSubnet(3pm)