AWK Command Post: 302682337

Sponsored Content

Top Forums Shell Programming and Scripting AWK Command Post 302682337 by elixir_sinari on Monday 6th of August 2012 06:06:09 AM

08-06-2012

Registered User

Quote:

Originally Posted by raj_saini20

Try this

Code:

awk -F"|" 'BEGIN{i=1}($7 ~ /Task started on a component/){if(!a[$9]){a[$9]=$1;b[$9]=$8;c[i]=$9;i++}}
($7 ~ /Exchange processing completed|Task completed on a component/){if(a[$9]){d[$9]=$1}}
END{for (j=1;j<i;j++){if(a[c[j]]&&d[c[j]]){split(a[c[j]],s_tm," ");split(d[c[j]],e_tm," ");
x=((substr(s_tm[2],1,2)*3600)+(substr(s_tm[2],4,2)*60)+substr(s_tm[2],7,2))*1000+substr(s_tm[2],10,3)
y=((substr(e_tm[2],1,2)*3600)+(substr(e_tm[2],4,2)*60)+substr(e_tm[2],7,2))*1000+substr(e_tm[2],10,3);print c[j]" "b[c[j]]" "y-x}}}' inputfile

Output is

Code:

jms:Send to Remit Splits              B678C56D-96DA-4FFC-B40E-9A032A2EB12E           400
 filesystem:Reports_5                  B678C56D-96DA-4FFC-B40E-9A032A2EB12E           249
 jms:JMS Inbound                       F7852A81-1BE0-42D6-83E1-8DAADF816CEC           190218
 scriptrunner:Copy Msg Props to Exchange   F7852A81-1BE0-42D6-83E1-8DAADF816CEC           570
 eip.router:Action                     F7852A81-1BE0-42D6-83E1-8DAADF816CEC           122778
 eip.router:Data Type                  F7852A81-1BE0-42D6-83E1-8DAADF816CEC           122774
 subroute.processor:Original Data Processing   F7852A81-1BE0-42D6-83E1-8DAADF816CEC           122770

Aww...reading that hurts.
Please try to present such humongous scripts in a better way.

elixir_sinari

View Public Profile for elixir_sinari

Find all posts by elixir_sinari

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...

LEARN ABOUT DEBIAN

ttk::label

ttk::label(3tk) 						 Tk Themed Widget						   ttk::label(3tk)

__________________________________________________________________________________________________________________________________________________

NAME

       ttk::label - Display a text string and/or image

SYNOPSIS

       ttk::label pathName ?options?
_________________________________________________________________

DESCRIPTION

       A ttk::label widget displays a textual label and/or image.  The label may be linked to a Tcl variable to automatically change the displayed
       text.

STANDARD OPTIONS

       -class		     -compound		  -cursor
       -image		     -style		  -takefocus
       -text		     -textvariable	  -underline
       -width

       See the ttk_widget manual entry for details on the standard options.

WIDGET-SPECIFIC OPTIONS
       Command-Line Name:-anchor
       Database Name:  anchor
       Database Class: Anchor

	      Specifies how the information in the widget is positioned relative to the inner margins.	Legal values are n, ne, e, se, s,  sw,	w,
	      nw, and center.  See also -justify.

       Command-Line Name:-background
       Database Name:  frameColor
       Database Class: FrameColor

	      The widget's background color.  If unspecified, the theme default is used.

       Command-Line Name:-font
       Database Name:  font
       Database Class: Font

	      Font to use for label text.

       Command-Line Name:-foreground
       Database Name:  textColor
       Database Class: TextColor

	      The widget's foreground color.  If unspecified, the theme default is used.

       Command-Line Name:-justify
       Database Name:  justify
       Database Class: Justify

	      If  there  are multiple lines of text, specifies how the lines are laid out relative to one another.  One of left, center, or right.
	      See also -anchor.

       Command-Line Name:-padding
       Database Name:  padding
       Database Class: Padding

	      Specifies the amount of extra space to allocate for the widget.  The padding is a list of up to four length specifications left  top
	      right bottom.  If fewer than four elements are specified, bottom defaults to top, right defaults to left, and top defaults to left.

       Command-Line Name:-relief
       Database Name:  relief
       Database Class: Relief

	      Specifies the 3-D effect desired for the widget border.  Valid values are flat, groove, raised, ridge, solid, and sunken.

       Command-Line Name:-text
       Database Name:  text
       Database Class: Text

	      Specifies a text string to be displayed inside the widget (unless overridden by -textvariable).

       Command-Line Name:-wraplength
       Database Name:  wrapLength
       Database Class: WrapLength

	      Specifies  the  maximum  line length (in pixels).  If this option is less than or equal to zero, then automatic wrapping is not per-
	      formed; otherwise the text is split into lines such that no line is longer than the specified value.

WIDGET COMMAND

       Supports the standard widget commands configure, cget, identify, instate, and state; see ttk::widget(3tk).

SEE ALSO

       ttk::widget(3tk), label(3tk)

Tk									8.5							   ttk::label(3tk)