Shell Programming and Scripting

Hi,
I would like to Join the Below mwntioned TWO Files.
File 1.txt
---------
99|Table1|00|5
99|Table2|00|10
99|Table3|00|15
99|Table1|04|7

File 2.txt
---------
99|Table1|00|INF1
99|Table2|00|INF2
99|Table3|00|INF3
99|Table1|04|INF4
99|Table4|04|INF5
99|Table2|04|INF6


Expected Output:
------------------
99|Table1|00|INF1|5
99|Table2|00|INF2|10
99|Table3|00|INF3|15
99|Table1|04|INF4|7
99|Table4|04|INF5|0
99|Table2|04|INF6|0
99|Table2|00|INF6|10


Basically the First 3 Fileds of File 1.txt and 2.txt needs to be mathced, if it matches then pick the 4th filed from the 1.txt and append it to the 2.txt file record.

Can any one help me?

Code:

#!/bin/ksh
clear
for i in `cat file1`
do
        first=`echo $i | cut -d"|" -f1`
        second=`echo $i | cut -d"|" -f2`
        third=`echo $i | cut -d"|" -f3`
        for j in `cat file2`
        do
                first2=`echo $j | cut -d"|" -f1`
                second2=`echo $j | cut -d"|" -f2`
                third2=`echo $j | cut -d"|" -f3`
                fourth2=`echo $j | cut -d"|" -f4`
                if [ $first -eq $first2 -a $second -eq $second2 -a $third -eq $third2 ]
                then
                        final=`echo $i | cut -d"|" -f4`
                        echo "$first|$second|$third|$fourth2|$final"
                fi
        done
done
 
 
 
Regards,
Jayan Jayaseelan

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

-----Post Update-----

Brrrr......

man join