Homework & Coursework Questions

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!

1. The problem statement, all variables and given/known data:
I have to join 3 files numerically according to ID(first column) with no comments. In the end i'll be something like this to a Marks file.

54546547 7 7 5
12345678 4 5 6
etc

What I think my problem is, is that there's something wrong with my first join. despite my final output being spaced correctly.

When i submit it to the system that checks my program it says:

Code:

 File: Marks
Expected: 26825845 4 8
Got: 26825845  4 8

I have 3 files Prac1, Prac2 and Prac3. Each student cannot have missed all pracs but can miss 2. So they have to have some marks.

Code:

# Results for Prac1. The format is:
# 12345678 10
32145645 4
12345678 7
321435355 3
4325325 3
54359506 5
4325459 5
87686546   
90948695

Code:

# Results for Prac2. The format is:
# 12345678 3
12345678  
32145645 3
87686546 9
4325459 5
90948695 3
321435355

Code:

# Results for Prac3. The format is:
# 12345678 3
12345678 1
87686546 8
32145645
321435355 3
54359506 4
4325325 3
90948695 7

2. Relevant commands, code, scripts, algorithms:
I must use join and sort nothing else. So no awk solutions. Must be sorted numerically.


3. The attempts at a solution (include all code and scripts):

Code:

grep -v "#" Prac1 | sort > Prac1temp1
grep -v "#" Prac2 | sort > Prac2temp2
join -a1 -a2 -o "0 1.2 2.2"  Prac1temp1 Prac2temp2 > part1temp1

grep -v "#" Prac3 | sort > Prac3temp3
join -a1 -a2 -t" " -e" " -o "0 1.2 1.3 2.2" part1temp1 Prac3temp3 > part1temp2
sort -n part1temp2 > Marks

part1temp1

Code:

12345678 7 
321435355 3 
32145645 4 3
4325325 3 
4325459 5 5
54359506 5 
87686546  9
90948695  3

Marks

Code:

4325325 3   3
4325459 5 5  
12345678 7   1
32145645 4 3  
54359506 5   4
87686546   9 8
90948695   3 7
321435355 3   3

If you notice in my final output(Marks) it's fine. sorted numerically, spacing is good. but in part1temp1 the id's 87686546 and 90948695's marks are supposed to have moved over by 1 space as they are prac2 marks.

4. Complete Name of School (University), City (State), Country, Name of Professor, and Course Number (Link to Course):
Monas University, Melbourne, Vic, Australia, John Hurst, FIT3042

Note: Without school/professor/course information, you will be banned if you post here! You must complete the entire template (not just parts of it).

sorry i've solved it. it was the way the question was written. didn't need to leave a space for empty pracs.