11-23-2013
Quote:
Originally Posted by
jaydeep_sadaria
Dear Akahsy
For while loop tag following error occur. Help. Last error but I cant find.
sh diff.sh
diff.sh: syntax error at line 2: `<' unexpected
atisdosh@gumas1n:~/PROJECT/Format_SMS$cat diff.sh
while read line; do
IFS=' '; read -r s1 s2 s3 s4 <<< $line
echo $line $(( ( $(date --date="$s1 $s2" +%s) - $(date --date="$s3 $s4" +%s) )/3600 ))
done < ip.txt
You have new mail in /var/mail/atisdosh
For awk code following error occur:
awk '{s=$1 " "$2;t=$3" "$4;gsub(/\-|:/," ",s);gsub(/\-|:/," ",t); print $0, int((mktime(s)-mktime(t))/3600)}' ip.txt
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: illegal statement near line 1
Regards
Jaydeep
---------- Post updated at 05:47 PM ---------- Previous update was at 05:40 PM ----------
Dear Akshay
gsub is not working. substr and split is working. What can be code for same.
Regards
Jaydeep
which OS ? if
Solaris/Sun OS then use
nawk
I am very sad that though you are member since 2007, you have been very consistent in not using codetag. and secondly you have not copied the code properly.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I am working on a korn shell script.
I have a problem.i am calculating the next 27 hours
from the time stamp.
say TSTAMP=20060724000000
if i add 27 hours to the above time stamp,
i will get 20060724143000
this is the code:
YEAR=`echo $TSTAMP | awk... (0 Replies)
Discussion started by: pavan_test
0 Replies
2. Shell Programming and Scripting
Hi
i want to print the time of a process in hours only..(or) in minutes only.Is there anyway to print the process such like that
when i give the commnand like following
#ps -eo pid,time
PID TIME
412 01:49:32
481 00:03
it shows in HH:MM:SS format:
Could anyone... (1 Reply)
Discussion started by: srikanthg
1 Replies
3. UNIX for Dummies Questions & Answers
Dear Folks,
I want to calculate the elapsed hours between two time columns. I am using timestampdiff method for the same. I am able to get the value. But facing an issue of decimal values. For example the elapsed hours between 09:00:00 and 20:30:00 is coming as 11 instead of 11.5. I am using below... (1 Reply)
Discussion started by: dinesh1985
1 Replies
4. Shell Programming and Scripting
Hi,
I am trying to design a script, which will monitor a log file, and it should dump all the rows that were logged between now and past four hours.
The date format within the logs is "2/Jan/2011:03:13:27". So I am using below command to substract four hours from the current time :
$... (8 Replies)
Discussion started by: john_prince
8 Replies
5. UNIX for Dummies Questions & Answers
I want to add a crontab entry which should execute for every 4 hours and that 4 hours calculation should begin from the current time.
Normally if I set the crontab entry like this,
00 */4 30 05 * root date >>/tmp/cronout
The above will execute the date command for every 4 hours like... (7 Replies)
Discussion started by: Ganeshwari
7 Replies
6. Shell Programming and Scripting
Hi Experts,
Can you please help me in transposing Datefield from rows to column and calculate the time difference for each of the Jobids:
Input File:
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012 12:36:26,JOB_5350
Required Output:... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
7. Shell Programming and Scripting
I have created the script to grep the errors from weblogic logs files and redirecting output to file.txt ...From file.txt I'm using awk command to collect the past 20 mins output...The script running from cron every 15 mins... The script working well...
Now the challenges, I'm trying to use... (27 Replies)
Discussion started by: zenkarthi
27 Replies
8. Shell Programming and Scripting
Guys i have 3 files,
but i want to compare and diff only the 2nd column
path=`/home/whois/doms`
for i in `cat domain.tx`
do
whois $i| sed -n '/Registry Registrant ID:/,/Registrant Email:/p' > $path/$i.registrant
whois $i| sed -n '/Registry Admin ID:/,/Admin Email:/p' > $path/$i.admin... (10 Replies)
Discussion started by: kenshinhimura
10 Replies
9. Shell Programming and Scripting
Gents,
Is there the way to increase hours (+3) to the data with the format following.
example
JDhhmmss
335193508
input
335193508
335203508
335213508
335223508
335233508
output
335223508
335233508
336003508
336013508 (14 Replies)
Discussion started by: jiam912
14 Replies
10. Shell Programming and Scripting
Hi All,
I have one file which contains time for request and response.
I want to calculate time difference in milliseconds for each line.
This file can contain 10K lines.
Sample file with 4 lines.
for first line.
Request Time: 15:23:45,255
Response Time: 15:23:45,258
Time diff... (6 Replies)
Discussion started by: Raza Ali
6 Replies
LEARN ABOUT DEBIAN
mysql::diff
MySQL::Diff(3pm) User Contributed Perl Documentation MySQL::Diff(3pm)
NAME
MySQL::Diff - Generates a database upgrade instruction set
SYNOPSIS
use MySQL::Diff;
my $md = MySQL::Diff->new( %options );
my $db1 = $md->register_db($ARGV[0], 1);
my $db2 = $md->register_db($ARGV[1], 2);
my $diffs = $md->diff();
DESCRIPTION
Generates the SQL instructions required to upgrade the first database to match the second.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
Fuller documentation will appear here in time :)
o register_db($name,$inx)
Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index
can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been
supplied.
o db1()
o db2()
Return the first and second databases registered via "register_db()".
o diff()
Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the
second.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff(3pm)