Bashscripts.org

Hello everyone.
I have 2 files that I need to compare and send text messages to.

File one has the following.........
11111 Lastname FirstName ParentLastName ParentFirstName 10digitnumber@vtext.net
22222 Lastname FirstName ParentLastName ParentFirstName 10digitnumber@vtext.net
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.
Thank you
Bo

I think there are a few ways you can do this sort of thing... once you find the student ID number, you should just be able to grep the grades file. For this type of data however, it might be worth learning MySQL.

I can use awk to show the appropriate fields, but how do I set multiple variables so that I can store student ID and 10digit@vtext.com and then get the grades to the appropriate sections in my grade file? I guess a question to start would be how would I assign or re-assign a variable for each line. For example if I do
awk '/@/ {print $1,$6}' emailphonetest it returns
33539 10digit@message.alltel.com
31826 10digit@vtext.com

How would I set a variable for both of these entries so that I could grep the grades file?
Thanks

rename files "filewithemails" and "filewtihgrades", this script does it, i hope all studen numbers like on example

All student numbers are the same length 5. Just so I understand this a little better....Could you explain
for ind in `cat filewithemails|cut -d " " -f1`
Thanks again for all your help