Shell Programming and Scripting

awk -F"|" 'NR==FNR{for(i=1;i<=NF;i++){a[$1,i]=$i;}; next;}{printf $1"|";for(i=2;i<=NF;i++){printf a[$1,i]" -> "$i (a[$1,(i+1)]?"|":"\n")}}' File1 File2

awk -F "|" 'BEGIN { OFS = "|" }
FNR == NR {
        a[$1] = NF
        for(i = 2; i <= NF; i++) a[$1,i] = $i
        next
}
{       for(i = 2; i <= NF; i++) $i = a[$1,i] " -> " $i
        print
}' File1 File2

1|fkgk
2|sfkgn
3|kfhd
4|hfj
5|fghfd
6|dsfjs
7|fbg.
8|dfds
9|efh

2|colour->red
3|colour->green
3|height->3
5|colour->
5|height->6
5|weight->4
8|colour->blue
8|weight->

1|fkgk|-
2|sfkgn|colour->red
3|kfhd|colour->green|height->3
4|hfj|-
5|fghfd|colour->|height->6|weight->4
6|dsfjs|-
7|fbg|-
8|dfds|colour->blue|weight->
9|efh|-

#!/bin/sh
rm debug.log
rm $3
fileA=$1
fileB=$2
fileC=$3
var=

cat $fileA|while read lineA
do
#get handle of fileA
Handle=`echo $lineA|awk -F"|" '{print $1}'`
echo "debug fileA handle:" $Handle >>debug.log
lineBhandle=`echo $
lineB=`grep -w $Handle $fileB`
echo "debug lineB :"$lineB>>debug.log
if [ -z "$lineB" ]
then
    echo "$lineA    -" >> $fileC
    echo "inside if ">>debug.log
else
    cat $fileB|while read lineC
    do
        file2handle=`echo $lineC|awk -F"|" '{print $1}'`
        echo "debug fileB handle:"$file2handle>>debug.log
        if [ $Handle -eq $file2handle ]
        then
            param=`echo $lineC|awk -F"|" '{print $2}'`
            var="$var $param"
        fi
    done
    echo "debug param:"$var>>debug.log
    echo "$lineA    $var">>$fileC
fi
done

awk -F "|" 'NR==FNR{X[$1]=X[$1]?X[$1]"|"$2:$2;next}{if(X[$1]){print $0"|"X[$1]}else{print $0"-"}}' fileB fileA

awk -F "|" 'NR==FNR{X[$1]=X[$1]?X[$1]"|"$2:$2;next}  # Read fileB - if X[$1] present then append $2 to the X[$1]. if not then assin $2 to X[$1]

{if(X[$1]){print $0"|"X[$1]}else{print $0"-"}}' fileB fileA   # Read fileA - if $1 presnet it fileA then print $0 and X[$1]. if not the print $0"-"