Shell Programming and Scripting

Can anyone please help me to create the output file based on the attached input files using ksh script.

I have 2 input files
1) inputfile1.txt
2) inputfile2.txt

The script should accept 2 parametes:

1. Inputfile2.txt with 1-10,000 values ( sample file contains only 4 records)
2. Script reads the above file and generates one separate output file(outputfile.txt) .

The only value that needs replaced is the 107 from inputfile1.txt(3rd column - delimter | -search 107=) with the values in the 2nd inputfile (inputfile2.txt). No other value should be replaced from inputfile1.txt.

The output should contain total 4 lines.

Thanks

Your inputfile1.txt file has UNIX line terminators.
Your inputfile2.txt and outputfile.txt files have DOS line terminators.

The following seems to do what you want, but uses UNIX line terminators instead of DOS line terminators in the output it produces:

Code:

awk -F '[[.^.]]A107=[^^]+[[.^.]]A' '
{	sub(/\r$/, "")
}
NR == 1 {
	f1 = $1 "^A107="
	f2 = "^A" $2
	next
}
{	print f1 $0 f2
}' inputfile1.txt inputfile2.txt > outputfile.txt

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk. (Note that nawk on a Solaris/SunOS system will not work in this case; you need an awk that correctly processes ERE collating symbol bracket expressions.)

Try also

Code:

awk 'FNR==NR {TMP=$0; next} {sub (/\^A107=[^^]*\^A/, "^A107=" $0 "^A", TMP); print TMP}' /tmp/inputfile1.txt /tmp/inputfile2.txt

If your files contain DOS line terminators, add a sub (/\r/,"") as Don Cragun proposed.

Unless I'm missing something, the code:

Code:

FNR==NR {TMP=$0; next}

in the above needs to be changed to:

Code:

NR == 1 {TMP=$0; next}

to keep from overwriting the template read from inputfile1.txt with the replacement data found on the first line of inputfile2.txt.

Well - yes and no. TMP wouldn't be overwritten by any line in inputfile2, but IF there were more than one line in inputfile1, only the last one were acted upon with my proposal, while only the first one were considered by Don Cragun's,

Yes. Sorry for confusing the issue.

In the first draft of my code, I had a typo that grabbed the 1st line from both files as the template (FNR == 1 instead of NR == 1) and when I saw your post a minute after my post, I thought you had fallen into the same trap. My mistake!