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 by vaildating the first field.I am using -KSH.

I am in real hurry. : Your help will be highly appreciated.

Table 1:

Cricket 16 28
Tennis 26 15
Wrestling 12 34

Table 2:
Cricket 25 26
***** 16 13
Wrestling 11 22

I need output as in table3.


Table 3:

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

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

Looks easy enough - can you explain why it's urgent? why it needs to be in awk? or is it just late homework you'd rather we did for you?

I have to findout the logic and I am learning "AWK" too.

Teach/suggest me if you can. Thanks for your consideration.

This site's not bad.

Read in data from files, assign values to arrays, print values out in required format, stop.

Hi...

I already know how to print this format. But my concern is that the program should validate the first field (As I specified earlier), then it must the print the O/P in required format.

Could you plz give me ur valuable inputs?

Validate it in what fashion, that it's spelt correctly? that it begins with a capital letter? that it's followed by 2 numbers?

I'd suggest you go along to classes, do any background reading and then do your own homework. If you can't be bothered to put any effort into it then why on earth should we?

@HUNTER

awk ' FILENAME==ARGV[1] { a[$1]=$2" "$3 }
FILENAME==ARGV[2] { if(a[$1]=="") {a[$1]="NA NA "$2" "$3 } else { a[$1]=a[$1]" "$2" "$3 } }
END { for(i in a) print i" "a[i]}' f1 f2 | sort |
awk '{ if(NF<4) { print $0" NA NA"} else { print $0 }}'


it will solve ur problem....

awk ' FILENAME==ARGV[1] { a[$1]=$2" "$3 }
FILENAME==ARGV[2] { if(a[$1]=="") {a[$1]="NA NA "$2" "$3 } else { a[$1]=a[$1]" "$2" "$3 } }
END { for(i in a) print i" "a[i]}' Table11 Table2 | sort |
awk '{ if(NF<4) { print $0" NA NA"} else { print $0 }}' > Table3


now Table3 will contain .... wt u want.......

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

Enjoyyyyyyyyyyyyyyyyyyy