Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Update time stamp and replace values

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Update time stamp and replace values
# 1  
Old 03-15-2016
Update time stamp and replace values
Can anyone please assist?

I need to grab each line between the lines "HEADER" and "TRAILER"

Each line contains two timestamps(Timestamp1) and (Timestamp2). I need to create two variables TIME_SUBSTRCT and TIME_ADD and

then recalculate the two timestamps using this logic:
START_TIME=Timestamp1 - ${TIME_SUBSTRACT}
END_TIME=Timestamp2 + ${TIME_ADD}
The final output should be each line with its new adjusted timestamps in place of the original timestamps.

eg. If timestamp1=09:17:00 and TIME_SUBSTRACT=10 , the START_TIME to be 09:07:00

If timestamp2=10:15:00 and TIME_ADD=15, the END_TIME to be 10:30:00

Code:
Input File:

HEADER
SERVER1 02/10/2016 10:13:00.000 02/10/2016 10:18:59.011 1123
SERVER2 02/10/2016 07:05:00.000 02/10/2016 08:10:59.011 1234
SERVER3 02/10/2016 06:32:00.000 02/10/2016 07:37:59.012 1567
SERVER4 02/11/2016 03:14:00.000 02/11/2016 08:19:59.134 1678
SERVER5 02/10/2016 11:48:00.000 02/10/2016 06:53:59.444 1790
TRAILER

Expected output:
Code:
SERVER1 02/10/2016 10:03:00.000 02/10/2016 10:33:59.011 1123
SERVER2 02/10/2016 06:55:00.000 02/10/2016 08:25:59.011 1234
SERVER3 02/10/2016 06:22:00.000 02/10/2016 07:52:59.012 1567
SERVER4 02/11/2016 03:04:00.000 02/11/2016 08:34:59.134 1678
SERVER5 02/10/2016 11:38:00.000 02/10/2016 07:08:59.444 1790

Code:
My Code:
######################
TIME_SUBSTRACT=10
TIME_ADD=15
InputFile=Inputfile.txt
ExtractFile=Extractfile.txt

awk '/HEADER/ {flag=1;next} /TRAILER/{flag=0} flag {print}' ${InputFile}  >${ExtractFile}

ReplaceValue()
{
awk  -v var="${START_TIME}" -v var1="${END_TIME}"  '{$3=var;$5=var1}1' ${ExtractFile} >outputfile.txt
}

cat ${ExtractFile} | while read line
do
TIMESTAMP1=`echo $line | awk '{print substr($3,1,8)}'`
TIMESTAMP2=`echo $line | awk '{print substr($5,1,8)}'`
START_TIME=`awk -v var="${TIME_SUBSTRACT}" -v var1="${TIMESTAMP1}" 'BEGIN{print strftime("%H:%M:%S",var1-(var*60))}'`
END_TIME=`awk -v var="${TIME_ADD}" -v var1="${TIMESTAMP2}" 'BEGIN{print strftime("%H:%M:%S",var1+(var*60))}'`
ReplaceValue
done

Few issues 1) Not getting correct start time and end time. 2) while replacing the older timestamp with new timestamp last part of columns 3 and 5 are missing(Ex:000,011). Tried using substr and its not working.

Thanks for your help in advance.

---------- Post updated 03-15-16 at 09:45 AM ---------- Previous update was 03-14-16 at 02:09 PM ----------

I'm getting correct start time and end time. I should be able to fix the code.

Thanks
Last edited by vinus; 03-14-2016 at 05:00 PM..
# 2  
Old 03-15-2016
I've got this for you, but it doesn't yield the correct seconds nor decimals:
Code:
awk  -vTS=-10 -vTA=+15 '
function GTM(T,D)       {cmd = "date +\"%d/%m/%Y %H:%M:%S.000\" -d\"" T D "min\""
                         cmd | getline X
                         close (cmd)
                         return X
                        }
NF == 1                 {print
                         next
                        }
                        {gsub (/:|:..\..*$/, "", $3)
                         gsub (/:|:..\..*$/, "", $5)
                         print $1, GTM($2 " " $3, TS), GTM($4 " " $5, TA), $6
                        }
'  file

This User Gave Thanks to RudiC For This Post:
vinus
# 3  
Old 03-15-2016
Rudic, Thanks a lot for your help !

I tried epoch time logic and my code is working fine.
# 4  
Old 03-16-2016
Hi RudiC,
after spending so much of time i am unable to understand the function used in code.
Code:
function GTM(T,D)       {cmd = "date +\"%d/%m/%Y %H:%M:%S.000\" -d\"" T D "min\""
                         cmd | getline X
                         close (cmd)
                         return X
                        }

till here i can discern that you got date value in T as 02/10/2016 1013 and -10 in D
.Could you please explain how cmd is being calculated specially -d and min in -d\"" T D "min\"". And here | is operating as OR or passing value from cmd to getline. Why we need to close cmd, because close is used to close file but cmd holds some value here.

Thanks,
Last edited by looney; 03-16-2016 at 04:07 PM..
# 5  
Old 03-16-2016
Yes, T is the time, and D is the delta. In awk, the | pipes the cmd command's result to getline. And, whatever the cmd is, it can and should be closed whenever the max open files is exceeded.

Why don't you print the cmd in the function just to see what's in there?
# 6  
Old 03-16-2016
If you have GNU awk you could use the mktime() and strftime() like this:

Code:
gawk -F "[ :/.]" -v TSUB=10 -v TADD=15 '
 /TRAILER/ {flg=0}
 flg {
   T1=mktime($4 " " $2 " " $3 " " $5 " " $6 " " $7)
   T2=mktime($11 " " $9 " " $10 " " $12 " " $13 " " $14)
   TS1=strftime("%m/%d/%Y %T",T1 - TSUB*60)"."$8
   TS2=strftime("%m/%d/%Y %T",T2 + TADD*60)"."$15
   print $1 , TS1 , TS2 , $16
 }
 /HEADER/ {flg=1}' infile > outfile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Logs between two time stamp

I am creating log monitoring script and stuck up to get the logs between two time stamp. can you please help me to create the script to get the logs between two time stamp, for example, I need the complete logs between # Time: 150328 1:30:10 and # Time: 150328 19:10:57 OS : Cent OS 6.x... (8 Replies)
Discussion started by: zenkarthi
8 Replies

2. UNIX for Advanced & Expert Users

Need mtime with time stamp

hi all find /folder1 -mtime 1 >folder1 with the above command , I can get the output of all the files which are modified(within folders and sub folders of folder1) in the last 24 hours. but the listed files output , does not contain the time stamp with it. I request you to give... (4 Replies)
Discussion started by: sidharthmellam
4 Replies

3. Shell Programming and Scripting

Time stamp Difference

I have a log file which wrote time stamp like this 2013-02-11 00:46:40.389037 2013-02-12 11:46:40.197045 can any one help me to get the time stamp difference of these two line in seconds. (4 Replies)
Discussion started by: netdbaind
4 Replies

4. Solaris

System time and Cron time stamp not matching

On Solaris 10 server the system date won't match with the timestamp on files created by a cron jobs, Please help here is what i get when i check for system date infodba-ie10ux014:/tcpdv1_ie10/tcadmin/bin\n\r-> date Tue Apr 24 15:27:43 GMT 2012at same time i executed a cron job, and checked... (4 Replies)
Discussion started by: karghum
4 Replies

5. Shell Programming and Scripting

change and replace time stamp

Hi, I want to convert normal time stamp to unix time stamp to a filename. coz our ssytem will pick depends on unix timestamp format . the filenames are as shown below fie names are stored in file say temp.txt. MLFG2_cDomHTTPstats_SAB15-1_1318482447.dat... (2 Replies)
Discussion started by: raghavendra.nsn
2 Replies

6. Shell Programming and Scripting

How to get time duration between two human readable time stamp in Unix?

Here is two time I have: Jul 12 16:02:01 Jul 13 01:02:01 and how can I do a simple match to get difference between two time which is 09:00:00 Thanks in advance. (3 Replies)
Discussion started by: ford99
3 Replies

7. Shell Programming and Scripting

regarding time stamp

hi everyone i am facing a strange problem here suppose content of my file is a=1,2,3 b=2,3,4 c=4,5,6 time= now the problem is i want to add value in front of time variable and the value should be i format only "HHMMSS" so it should be like this a=1,2,3 b=2,3,4 c=4,5,6... (3 Replies)
Discussion started by: aishsimplesweet
3 Replies

8. Shell Programming and Scripting

Time stamp calculation

Hi all; I'm relatively new to scripting,I am working on a monitoring script.....where in i have to write subroutine which does the follows: It will check the time stamp of a file ( Oracle remarchive files) and compare it with existing time.If the time difference happen to be more than 90... (6 Replies)
Discussion started by: maverick_here
6 Replies

9. UNIX for Dummies Questions & Answers

checking time stamp

Hi, I am having a script in which I am again calling a script, but before calling that script I need to perform a time check (say 1 - 2 am i.e. I would be able to call that script if time is between 1:00 am and 2:00 am) but this time stamp needs to be configurable. can anybody suggest me how... (7 Replies)
Discussion started by: Manvar Khan
7 Replies

10. Shell Programming and Scripting

greping with time stamp

Hi all, I want to grep a file name with time stamp as 30 minutes how can i??. Ex I will getting outputs in a file every minutes I want to grep it by a time intervals of 30 and show it . Any help will be great ! Thanks, Arun. (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
Login or Register to Ask a Question