AWK Looping. How can I get expected result? Post: 302769000

Sponsored Content

Top Forums Shell Programming and Scripting AWK Looping. How can I get expected result? Post 302769000 by Akshay Hegde on Monday 11th of February 2013 03:36:39 AM

02-11-2013

Moderator

problem here is I could not able to trace where internal loop is ending and where outer loop is ending .

here it was suppose to do like this repeat following statements 2440 times, after that come out of loop, print if statement is true else increment outer loop(i).. again repeat following statements 2440 times...

Code:

if(A[1,j,2]>=A[2,i,2]-0.1 && A[1,j,2]<=A[2,i,2]+0.1)            # Comparison starts here
{
if(A[1,j,1]>=A[2,i,1])x=x+1;                           
if(A[1,j,1]<=A[2,i,1])y=y+1;
}

Code:

instead of printing result after every increment of i its printing result at last value of i (thats i=218)
except 
Code:

if(x>=1 && y>=1) is false

I hope you will understand

This is that logic, I had posted earlier unfortunately nobody helped, Thank God at least you asked me..what you want to do

1 . First read column 1 and column 2 of file1.plo store it in array(reference)

2 . Now read column 1 and column 2 of file2.plo store it in another array,to be compared with reference

3 . for loop : - for(i=1;i<=file2.plo_length;i++)

4 . x=0; y=0 this will get clear as and when i will increment

5 . nested loop :- for(j=1;j<=file1.plo_lenght;j++)

6 . if(col1_f1[j]>=col1_f2-0.1[i] && col1_f1[j]<=col1_f2+0.1[i])

if above if statement is true then,go to following statement else check condition with j++

7 . if(col2_f2[i]>=col2_f1[j]) then x=x+1

8 . if(col2_f2[i]<=col2_f1[j]) then y=y+1

repeat 5,6,7 and 8 till j reaches file1.txt_length(NR),Once j reaches NR following

9 . if(x>=1 && y>=1) then print column1_f2[i] column2_f2[i]

repeat statements after number 4 to 9 till i reaches file2.plo_length(NR)

Last edited by Akshay Hegde; 02-11-2013 at 04:56 AM..

Akshay Hegde

View Public Profile for Akshay Hegde

Find all posts by Akshay Hegde

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Looping in awk

Can somebody give me a cleaner way of writing the following script. I was thinking that I could use a loop in the awk statement. It works fine the way it is but I just want the script to be cleaner. #!/usr/bin/sh for r in 0 1 2 3 4 5 6 do DAY=`gdate --date="${r} days ago" +%m\/%d\/%y`...

2. UNIX for Advanced & Expert Users

executing script by cron doesnt give me expected result

Hi frnds... I m facing very irritating problem already waisted my 2 days.. I have a following script..( i am pasting only the main code) ftp -ivn 213.194.40.77 <<FTP user $user $password binary cd $FileDir/out lcd $localpath get $file rename $FileDir/out/$file $FileDir/tmp/$file...

3. UNIX for Dummies Questions & Answers

Help with AWK looping

I'm trying to parse a configuration text file using awk. The following is a sample from the file I'm searching. I can retrieve the formula and recipe names easily but now I want to take it one step farther. In addition to the formula name, I would like to also get the value of the attribute...

4. Programming

Test program not giving expected result

I have five classes. 2 composition classes,1 aggregation class and 1 dependency class.I have coded all the classes but one of my test program is not giving me the expected result.I have the following classes: TimeStamp Interval (composition of 2 TimeStamps) TimeSheet ( aggregation of many...

5. Shell Programming and Scripting

looping in awk

How do I remove last comma? echo "xx yy zz" | awk 'BEGIN{FS=" "}{for (i=1; i<=NF; i++) printf "%s,", $i}'output: xx,yy,zz, required output: xx,yy,zz or (ideally!): xx, yy & zz many thanks in advance!

6. Shell Programming and Scripting

Result of Catching Return Value from Sub_script.sh to Main_script.sh is not as Expected

Main_script.sh #! /bin/sh ./Sub_script.sh rc=$? echo "Return code from Sub_script.sh : $rc" if ; then echo "$rc = 991" echo "" exit 1 elif ; then echo "$rc = 992" echo "" exit 1 elif ; then echo "$rc = 0" echo "" exit 1 fi

7. Shell Programming and Scripting

Help on looping using awk

I have the data like this: PONUMBER,SUPPLIER,LINEITEM,SPLITLINE,LINEAMOUNT,CURRENCY IR5555,Supplier1,1,1,83.1,USD IR5555,Supplier1,1,3,40.4,USD IR5555,Supplier1,1,6,54.1,USD IR5555,Supplier1,1,8,75.1,USD IR5556,Supplier2,1,1,41.1,USD IR5556,Supplier2,1,3,43.1,USD ...

8. Shell Programming and Scripting

Assigning variable to output gives error with expected result

Hello, I am trying to print out the first string matching query with grep and I need your help. My scenario: Database John F 4433 Street No 88 CA Elisabeth Taylor 7733 Street No 26 ON Jack Nicholson 0133 Green Park No 34 AR John F 2 9399 Southpark No 02D UT test.sh...

9. Shell Programming and Scripting

Not getting expected result

Hi Experts, I have written the below script but its not working as per expectation. My requirement is if this condition ] is satisfied then only check for this condition ] if this also satisfied check for the condition ]. vi p_values.ksh path="/db/ora/files" mode=1 b_days=10...

10. Shell Programming and Scripting

Grep output to file result not as expected

Hi Gurus, I run command grep ABC file1 > file2 against below file. I got all ABC_xxx in one line in file2. I expect to get multiple lines in file2. If I print result in screen, the result is expected. thanks in advance My os is SunOS 5.10 Generic_150400-64 sun4v sparc sun4v ABC_123 XXXXX...

LEARN ABOUT HPUX

comm

comm(1) 						      General Commands Manual							   comm(1)

NAME

       comm - select or reject lines common to two sorted files

SYNOPSIS

       file1 file2

DESCRIPTION

       comm  reads  file1  and	file2, which should be ordered in increasing collating sequence (see sort(1) and Environment Variables below), and
       produces a three-column output:

	      Column 1:   Lines that appear only in file1,
	      Column 2:   Lines that appear only in file2,
	      Column 3:   Lines that appear in both files.

       If is used for file1 or file2, the standard input is used.

       Options 1, 2, or 3 suppress printing of the corresponding column.  Thus prints only the lines common to the two files; prints only lines in
       the first file but not in the second; does nothing useful.

EXTERNAL INFLUENCES

   Environment Variables
       determines the collating sequence expects from the input files.

       determines the language in which messages are displayed.

       If is not specified in the environment or is set to the empty string, the value of determines the language in which messages are displayed.
       If is not specified in the environment or is set to the empty string, the value of is used as a default.  If is not specified or is set	to
       the  empty  string,  a  default of ``C'' (see lang(5)) is used instead of If any internationalization variable contains an invalid setting,
       behaves as if all internationalization variables are set to ``C''.  See environ(5).

   International Code Set Support
       Single- and multi-byte character code sets are supported.

EXAMPLES

       The following examples assume that and have been ordered in the collating sequence defined by the or environment variable.

       Print all lines common to and (in other words, print column 3):

       Print all lines that appear in but not in (in other words, print column 1):

       Print all lines that appear in but not in (in other words, print column 2):

SEE ALSO

       cmp(1), diff(1), sdiff(1), sort(1), uniq(1).

STANDARDS CONFORMANCE

																	   comm(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Looping in awk

Discussion started by: keelba

2. UNIX for Advanced & Expert Users

executing script by cron doesnt give me expected result

Discussion started by: clx

3. UNIX for Dummies Questions & Answers

Help with AWK looping

Discussion started by: new2awk

4. Programming

Test program not giving expected result

Discussion started by: moraks007