[Hunter]

Hi Experts,

I have a problem. Can you Help me?

I need a UNIX shell script for the below logic using AWK. The logic must lay on validating the first field. I am using -KSH.

I am in real hurry . I have to deliver ASAP

Table 1:

Cricket 16 28
Tennis 26 15
Wrestling 12 34

Table 2:

Cricket 25 26
Rugby 16 13
Wrestling 11 22

I need output as in table3.


Table 3:

Cricket 16 28 25 26
Rugby NA NA 16 13
Tennis 26 15 NA NA
Wrestling 12 34 11 22

If any questions plz ask me. Thankyou for your consideration.

[Hunter]

Guys/Gals,

I found "join" command will help.

join -a1 -a2 -e "NA" File1 File2

Thanks for viewing this post 44 times.