awk script: loop through array Post: 302872519

Sponsored Content

Top Forums Shell Programming and Scripting awk script: loop through array Post 302872519 by ENG_MOHD on Friday 8th of November 2013 01:46:46 PM

11-08-2013

Registered User

awk script: loop through array

I have a large file where I want to extract the data by using awk script. I have made a small sample of the input data. I have in the awk script two condition . The first one is to collect the initial time and the second one to collect the end time. I stored the difference between (Time=end-start) in an array. However, when I'm trying to loop through the array to print the results, I'm not getting the difference correct. It seems the code storing the end time in the Time array instead of the difference.

here is the sample ;

Code:

+ 0.1 5 0 tcp 40 ------- 1 5.0 2.0 0 0
- 0.1 5 0 tcp 40 ------- 1 5.0 2.0 0 0
r 0.102032 5 0 tcp 40 ------- 1 5.0 2.0 0 0
+ 0.102032 0 1 tcp 40 ------- 1 5.0 2.0 0 0
- 0.102032 0 1 tcp 40 ------- 1 5.0 2.0 0 0
r 0.108096 0 1 tcp 40 ------- 1 5.0 2.0 0 0
+ 0.108096 1 2 tcp 40 ------- 1 5.0 2.0 0 0
- 0.108096 1 2 tcp 40 ------- 1 5.0 2.0 0 0
r 0.110128 1 2 tcp 40 ------- 1 5.0 2.0 0 0
+ 0.110128 2 1 ack 40 ------- 1 2.0 5.0 0 2
- 0.110128 2 1 ack 40 ------- 1 2.0 5.0 0 2
r 0.11216 2 1 ack 40 ------- 1 2.0 5.0 0 2
+ 0.11216 1 0 ack 40 ------- 1 2.0 5.0 0 2
- 0.11216 1 0 ack 40 ------- 1 2.0 5.0 0 2
r 0.118224 1 0 ack 40 ------- 1 2.0 5.0 0 2
+ 0.118224 0 5 ack 40 ------- 1 2.0 5.0 0 2
- 0.118224 0 5 ack 40 ------- 1 2.0 5.0 0 2
r 0.120256 0 5 ack 40 ------- 1 2.0 5.0 0 2

and here is my code:

Code:

 BEGIN{
	  split("", time)
         }

$1 ~ /^\+/ && $10~/^2\..*/ &&  $4==0 &&$8 ==1 && $5=="tcp" && $6==40 {
                                          t_arr[$12] = $2;
					 print "start time " $2
}

$1 ~ /^r/  && $9 ~/^2\..*/ && $3==0&& $8 ==1 && $5=="ack" && $6==40{
                                      time[$12] = $2 - t_arr[$12]
				      print "end time " $2
}
							
END{
      for( i in time){
          print "time : " time[i]
       }
			

  }

any suggestions what is the problem ??? Smilie

ENG_MOHD

View Public Profile for ENG_MOHD

Find all posts by ENG_MOHD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with awk in array in while loop

Hi everyone:) I have 2 files - IN & OUT. Example: IN A:13:30 B:45:40 . . . UNLIMITED OUT Z:12:24 Y:20:15 . . . UNLIMITED I want first row of numbers of IN - OUT. Example 13-12 45-20 My code is

2. Shell Programming and Scripting

Help with gawk array, loop in tcsh script

Hi, I'm trying to break a large csv file into smaller files and use unique values for the file names. The shell script i'm using is tcsh and i'm after a gawk one-liner to get the desired outcome. To keep things simple I have the following example with the desired output. fruitlist.csv apples...

3. Shell Programming and Scripting

Help with awk array syntax & counting script

.....

4. Shell Programming and Scripting

awk output error while loop through array

Have built this script, the output is what I needed, but NR 6 is omitted. Why? Is it an error? I am using Gawk. '{nr=$2;f = $1} END{for (i=1;i<=f;i++) if (nr != i) print i, nr }' input1.csv >output1.csvinput1.csv 1 9 3 5 4 1 7 6 8 5 10 6 output1.csv > with the missing line number 6. 6 is...

5. Shell Programming and Scripting

Array Variable being Assigned Values in Loop, But Gone when Loop Completes???

Hello All, Maybe I'm Missing something here but I have NOOO idea what the heck is going on with this....? I have a Variable that contains a PATTERN of what I'm considering "Illegal Characters". So what I'm doing is looping through a string containing some of these "Illegal Characters". Now...

6. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ...

7. Linux

Problem with my loop and awk script

Sorry if this is a super simple issue, but am extremely new to this and am trying to teach myself as I go along. But can someone please help me out? I have a data file similar to this for many samples, for all chromosomes Sample Chr bp p roh Sample1 1 49598178 0 1...

8. Shell Programming and Scripting

Shell script to loop and store in array

I'm trying to achieve the follwoinig with no luck. Find the directories that are greater than 50GB in size and pick the owner of the directory as I would like to send an alert notification. du -sh * | sort -rh 139G Dir_1 84G Dir_2 15G Dir_3 ls -l Dir_1 drwx------ 2...

9. Shell Programming and Scripting

Unable to print python array in shell script loop.

I am unable to loop print a python string array in my unix shell script: ~/readarr.sh '{{ myarr }}' more readarr.sh echo "Parameter 1:"$1 MYARRAY= $1 IFS= MYARRAY=`python <<< "print ' '.join($MYARRAY)"` for a in "$MYARRAY"; do echo "Printing Array: $a" done Can you...

10. UNIX for Beginners Questions & Answers

sed inside the awk script to replace a string in the array

The requirement is i need to find an array value matching with pattern {5:{ , replace that with 5: and reassign that to same array index and print it. I write something like below and the issue is sed command is not working. If i replace " with "`" the script gives syntax error.how can i...

LEARN ABOUT SUNOS

tcp

tcp.h(3HEAD)							      Headers							      tcp.h(3HEAD)

NAME

       tcp.h, tcp - definitions for the Internet Transmission Control Protocol (TCP)

SYNOPSIS

       #include <netinet/tcp.h>

DESCRIPTION

       The <netinet/tcp.h> header defines the following macro for use as a socket option at the IPPROTO_TCP level:

       TCP_NODELAY     Avoid coalescing of small segments.

       The macro is defined in the header. The implementation need not allow the value of the option to be set with setsockopt() or retrieved with
       getsockopt().

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       getsockopt(3XNET), socket.h(3HEAD), attributes(5), standards(5)

SunOS 5.10							    10 Sep 2004 						      tcp.h(3HEAD)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with awk in array in while loop

Discussion started by: vincyoxy

2. Shell Programming and Scripting

Help with gawk array, loop in tcsh script

Discussion started by: theflamingmoe

3. Shell Programming and Scripting

Help with awk array syntax & counting script

Discussion started by: elbee11

4. Shell Programming and Scripting

awk output error while loop through array

Discussion started by: sdf

5. Shell Programming and Scripting

Array Variable being Assigned Values in Loop, But Gone when Loop Completes???

Discussion started by: mrm5102

6. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Discussion started by: klane

7. Linux

Problem with my loop and awk script

Discussion started by: vuvuzelo