Shell Programming and Scripting

- I am looking for different kind of awk solution which I don't think is mentioned before in these forums.

Number of rows in the file are fixed
Their are two columns in file1.txt

1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10


I am looking for 3 scenarios.
- If column 1 and 2 are same then generate PASS in Third Column (I have figured out this).
- If a number in Column 1 is less than column 2 (which means a number is missing in column 2)then
--generate FAIL in Column 3.
-- Move the number in Column 2 of that row to next row. Move all the numbers in column 2 after that number in thier next rows.
-- generate MISSING In Column 2.

-- Below is the example

file1.txt
1 1
2 3
3 4
4 5
5 7
6 8
7 9
8 10
9
10

As per second scenario what I want is

file1.txt
1 1 PASS
2 MISSING FAIL
3 3 PASS
4 4 PASS
5 5 PASS
6 MISSING FAIL
7 7 PASS
8 8 PASS
9 9 PASS
10 10 PASS

- If a number in Column 1 is greater than column 2 (which means a number is missing in column 1)then
--generate FAIL in Column 3.
-- Move the number in Column 1 of that row to next row. Move all the numbers in column 1 after that row in their next rows.
-- generate MISSING in Column 1.
-- Below is the example

file1.txt
1 1
3 2
4 3
5 4
7 5
8 6
9 7
10 8
9
10

As per third scenario what I want is

file2.txt
1 1 PASS
MISSING 2 FAIL
3 3 PASS
4 4 PASS
5 5 PASS
MISSING 6 FAIL
7 7 PASS
8 8 PASS
9 9 PASS
10 10 PASS


- I have figured out PASS FAIL logic which is basically comparison between 2 columns. But I am not able to figure out moving rows logic.
- Any help for this is really appreciated.

Try and adapt the following AWK program :

Code:

awk '
{ f1[NR] = $1 ; f2[NR] = $2 }
END {
   for (i=1; i<=NR; i++) {
      if (f1[i] == f2[i]) {
         f3 = "PASS"
      } else if (f1[i] < f2[i]) {
         for (j=NR; j>i; j--)
            f2[j] = f2[j-1];
         f2[i] = "MISSING";
         f3    = "FAIL";
     } else {
        for (j=NR; j>i; j--) {
           if (f2[j] == "")
              f2[j] = f1[j];
           f1[j] = f1[j-1];
        }
        f1[i] = "MISSING";
        f3    = "FAIL";
     }
     print f1[i], f2[i], f3
   }
}
' inputfile

Jean-Pierre.