A possible way :
Modify your input files :
Code:
username firstname secondname group,score
and try something like that :
Code:
join -t, -a 1 -a 2 -o 0 1.2 2.2 -e "0" ass1.$$ ass2.$$ |
join -t, -a 1 -a 2 -o 0 1.2 1.3 2.2 -e "0" - ass3.$$ |
join -t, -a 1 -a 2 -o 0 1.2 1.3 1.4 2.2 -e "0" - ass4.$$ > sorted.$$
Jean-Pierre.
|
