I have 2 files that I need to compare and send text messages to.
File one has the following.........
11111 Lastname FirstName ParentLastName ParentFirstName firstname.lastname@example.org
22222 Lastname FirstName ParentLastName ParentFirstName email@example.com
and so on and so on. The first field is the student number. Some of the entries have no last field like so
33333 Lastname FirstName ParentLastName ParentFirstName
My other file looks like the following.....
00001 11111 Subject 8 A
00002 11111 Subject 8 C+
00003 11111 Subject 8 B
00004 22222 Subject 12 A
00005 22222 Subject 11 F
00006 22222 Subject 12 C
What i would like to have done is an text message be send via the mailto command so that any students with a email addrs in file one get the grades corresponding to file 2. So that the text message would look like
22222 Subject 12 A
22222 Subject 11 F
22222 Subject 12 C
Any ideas would be greatly appreciated. I have been using awk to print the correct fields but am having trouble matching the student number in file to to mail the correct grades.
Again any input would be greatly appreciated.