Shell Programming and Scripting

Hi All,

I have a problem with my awk script. I am trying to append the whole line to another file called " file.txt " but i can't. I suppose there's something wrong in the way that i pipe. I canot use " nawk -f awk_script input > file.txt " because i have a 2nd input.
Can any expert give some advise?

Input:
wwwwww
0999 k= 1
0999 bb= 111
wwwwww
** QQQAAAR1 ccc ccc cc cc ccc 2007
wwwwww
wwwwww
0001 k= 1
0001 bb= 222
wwwwww
0002 k= 1
0002 *bb= 333
** abc ccc cc cc cc cc 2007
wwwwww
0001 k= 1
0001 bb= 444
wwwwww
0002 k= 1
0002 bb= 555
wwwwww
wwwwww
0003 k= 1
0003 bb= 666
wwwwww
** QQQAAAR1 ccc ccc cc cc ccc 2007
wwwwww
0003 k= 1
0003 bb= 777
wwwwww
0004 k= 1
0004 *bb= 888
0005 k= 1
0005 bb= 999

Code:

FNR==NR && $1 == "**" && $2 ~ /^QQQ/ && $2 ~ /R1$/ && $8 == "2007" {
CODE = $2 ;print $0|getline > file.txt ; next};

Code:

nawk 'NR == FNR && /^** QQQ[^ ]*R1 .* 2007$/ {
	CODE = $2
	print > "file.txt"
	next
}' filename

Thanks radoulov!!! It worked!!
But i don;t really understand this portion of the code " /^** QQQ[^ ]*R1 .* 2007$/ " .
Can you help me understand it better ?

It's a regular expression that matches the records that
begin with ** (^ anchors the beginning of the line)
followed by QQQ, then [^ ]* means zero or more occurrences
of characters other than a space: "^" as the first character
after the "[" indicates character(s) except those
in square brackets, followed by a literal R1, space and
zero or more occurrences of any character followed by
a space and 2007 at the end of the line.

Thanks radoulov!!!
You are such a pro at this!!