AWK Command Post: 302682803

Sponsored Content

Top Forums Shell Programming and Scripting AWK Command Post 302682803 by Prachi Gupta on Tuesday 7th of August 2012 01:56:28 AM

08-07-2012

Registered User

Thanks for the valuable input.
But i have few queries...
I tried running it again but its not giving output for few set of lines which are part of a complete big file.

and also the condition for fetching the end time.
Because the output is not same as per my calculations

The output its giving is:

Code:

 filesystem:CERR               B678C56D-96DA-4FFC-B40E-9A032A2EB12E          324118

But as per my calculations it should be

Code:

filesystem:CERR                B678C56D-96DA-4FFC-B40E-9A032A2EB12E         42263

The timings for this component are according to my calculations

Code:

Start time  37727981   (10:28:47.981)
End time    37770244   (10:29:30.244)

Timings according to the code are

Code:

Start time  37727981   (10:28:47.981)
End time    38052099

So can you please explain the second condition?

The set of line for this output are

Code:

2012-05-09 10:28:47.981 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | filesystem:CERR                     | {}
2012-05-09 10:28:47.995 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | xengine:Validation, Split           | {}
2012-05-09 10:29:14.284 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | xengine:CERR to ECR CF              | {}
2012-05-09 10:29:28.679 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | service.adapter:UCF Version Creator | {}
2012-05-09 10:29:29.846 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | jms:Send to Remit Splits            | {}
2012-05-09 10:29:29.997 | SYNC  | 00041 | DEBUG   | Customer_Receive Payment | Task            | Task started on a component            | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | filesystem:Reports_5                | {}
2012-05-09 10:29:29.979 | SYNC  | 00052 | DEBUG   | Customer_Receive Payment | Exchange        | Exchange processing completed          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E-0000005  | jms:Send to Remit Splits            | {}
2012-05-09 10:29:29.980 | SYNC  | 00052 | DEBUG   | Customer_Receive Payment | Exchange        | Exchange processing completed          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E-0000004  | service.adapter:UCF Version Creator | {}
2012-05-09 10:29:30.028 | SYNC  | 00052 | DEBUG   | Customer_Receive Payment | Exchange        | Exchange processing completed          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E-0000006  | filesystem:Reports_5                | {}
2012-05-09 10:29:30.041 | SYNC  | 00052 | DEBUG   | Customer_Receive Payment | Exchange        | Exchange processing completed          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E-0000003  | xengine:CERR to ECR CF              | {}
2012-05-09 10:29:30.231 | SYNC  | 00052 | DEBUG   | Customer_Receive Payment | Exchange        | Exchange processing completed          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E-0000000  | xengine:Validation, Split           | {}
2012-05-09 10:29:30.237 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | xengine:Validation, Split           | {}
2012-05-09 10:29:30.239 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | service.adapter:UCF Version Creator | {}
2012-05-09 10:29:30.244 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | filesystem:CERR                     | {}
2012-05-09 10:29:30.245 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | xengine:CERR to ECR CF              | {}
2012-05-09 10:29:30.246 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | filesystem:Reports_5                | {}
2012-05-09 10:29:30.246 | SYNC  | 00042 | DEBUG   | Customer_Receive Payment | Task            | Task completed on a component          | B678C56D-96DA-4FFC-B40E-9A032A2EB12E          | jms:Send to Remit Splits            | {}

Prachi Gupta

View Public Profile for Prachi Gupta

Find all posts by Prachi Gupta

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

assign a command line argument and a unix command to awk variables

Hi , I have a piece of code ...wherein I need to assign the following ... 1) A command line argument to a variable e.g origCount=ARGV 2) A unix command to a variable e.g result=`wc -l testFile.txt` in my awk shell script When I do this : print "origCount" origCount --> I get the...

2. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Sorry for the duplicate thread this one is similar to the one in https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121 Since there were no responses on the parent thread since it got resolved partially i thought to open the new...

3. UNIX for Dummies Questions & Answers

Basic awk question...getting awk to act on $1 of the command itself

I have a script problem that I am not able to solve due my very limited understanding of unix/awk. This is the contents of test.sh awk '{print $1}' From the prompt if I enter: ./test.sh Hello World I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello...

4. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

input1 a_a a/a 10 100 a1 a_a 20 200 b1 b_b 30 300 input2 a_a a/a xxx yyy a1 a1 lll ppp b1 b_b kkk ooo output a_a a/a 10 100 xxx yyy

5. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Hello all, Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val: > cat getnon0file.sh #!/bin/bash this="getnon0file.sh" USAGE=$this" InFile="xyz.38" Min="0.05" # awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};...

6. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the...

7. Shell Programming and Scripting

Multiple command execution inside awk command during xml parsing

below is the output xml string from some other command and i will be parsing it using awk cat /tmp/alerts.xml <Alert id="10102" name="APP-DS-ds_ha-140018-componentFailure-S" alertDefinitionId="13982" resourceId="11427" ctime="1359453507621" fixed="false" reason="If Event/Log Level(ANY) and...

8. Shell Programming and Scripting

Pass awk field to a command line executed within awk

Hi, I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date). All my attempts failed this far. Here's an example. It works fine with timestamp hard-codded into the command echo "1381653229 something" |awk 'BEGIN{cmd="date -d...

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

assign a command line argument and a unix command to awk variables

Discussion started by: sweta_doshi

2. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Discussion started by: rajan_san

3. UNIX for Dummies Questions & Answers

Basic awk question...getting awk to act on $1 of the command itself

Discussion started by: JasonHamm

4. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

Discussion started by: ruby_sgp

5. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Discussion started by: catalys

6. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Discussion started by: anandek

7. Shell Programming and Scripting

Multiple command execution inside awk command during xml parsing

Discussion started by: vivek d r

8. Shell Programming and Scripting

Pass awk field to a command line executed within awk

Discussion started by: tuxer