Hi,
I want to compare two | delimited files.Awk is not working in my unix box.So plz give alternate solutions.

Please see the below code:

file1=$1
file2=$2

num_of_records_file1=`awk ' END { print NR } ' $file1`
num_of_records_file2=`awk ' END { print NR } ' $file2`

i=1
while [ "$i" -le "$num_of_records_file1" ]
do
sed -n "$i"p $file1 > file1_temp
sed -n "$i"p $file2 > file2_temp

diff file1_temp file2_temp>file_temp

echo "Comparing $i line of fil1 with file2:"
awk NR==2 file_temp|sed 's/</Old:/g'
awk NR==4 file_temp|sed 's/>/New:/g'
i=`expr $i + 1`
done

I have 2 files File1.txt and File2.txt

File1.txt
123|Rosy|Chicago|
234|stella|michigan|
999|Richard|NJ|

File2.txt
123|Rosy|Chicago|
235|Stella|michigan|
999|Richard|NJ|ABN

I want to compare the two files and get the output as below:
Old:234|stella|michigan
New:235|Stella|michigan|

cnt=1
for line in `comm -3 a.txt b.txt | paste - -`
do
        if [ "$cnt" -eq "2" ]
        then
                echo "Old:"$prev
                echo "New:"$line
                cnt=1
        else
                cnt=`expr $cnt + 1`
                prev="$line"
        fi
done

Doesn't the lack of an ABN at the end of the last file count as a difference?

I can't get paste - - to do anything useful here, and the approach by manosubsulo seems a bit inefficient. Besides, comm requires sorted input, which does not seem to apply here.

What's wrong with just running diff on the two files?

diff a.txt b.txt | sed -e 's/^< /Old:/' -e 's/^> /New: /'

Era,

as per suggestion, sample output will be as,

2,3c2,3
Old:234|stella|michigan|
Old:999|Richard|NJ|
---
New: 235|Stella|michigan|
New: 999|Richard|NJ|ABN

But autosys_nm needs the output in different format.

Well, the removal of the diff annotations isn't hard to add to the sed script, and whether or not the Old: and New: lines should be adjacent or not isn't clearly specified. If they are required to be adjacent, perhaps sort the output from diff on the first field?

diff a.txt b.txt | sort -d -t '|' -n | sed -n -e 's/^< /Old: /p' -e 's/^> /New: /p'