Shell Programming and Scripting

A normalized version of the original script presented in post #1 in this thread with the corrections needed is:

Code:

awk '
BEGIN {	OFS="\t"
	out = "File3.txt"
}
NR == FNR {
	if(NF)
		a[substr($0,1,8)]=$0
	next
}
function print_77_99() {
	if(key in a)
		print "77", a[key] > out
}
$1 == "01" {
	if(FNR > 1)
		print_77_99()
	key = $4 $3 $2
}
{	print > out
}
END {	print_77_99()
}' File2.txt File1.txt

The primary changes are marked in red. All references to line have been removed since they were not used.

The only substantive difference between this code and the code RudiC posted in the other thread is that RudiC's script has an else clause on the if in print_77_99() because the specification in this thread doesn't produce any output if there is no matching key in File2.txt.

With the sample input files shown in the 1st post in this thread, the above script writes the following text into File3.txt:

Code:

01  89  68  5000
02  83  11
04  83  9   02
03  83  00
06  83  00
07  83  11  RT0429
77	50006889RT0429 NARD /3010  /E     /C A87545457          /  //                ///11        ///
01  44  73  8800
02  44  73
04  44  73   02
03  44  73
06  44  73
07  44  11  RT  0789

If someone wants to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.

@RudiC I tried modifying the script but it is still not working. Is it possible if you can modify my script? I want to know what exactly you meant
Thanks,

What - beyond what Don Cragun suggested - do you want modified? If I remember correctly, the "extended" record WAS printed after the "07" record.

Have you looked at message #8 in this thread?

I started with your code, and I thought I made it do exactly what you said you wanted it to do. What is the code I suggested in that post doing wrong?

Thanks a lot Don.
Code in Reply #8 worked for me...
I wasnt testing it properly.
Bundle of thanks.