Shell Programming and Scripting

i am new to unix shell scripting, could someone please help me. i was asked to develop a unix script and requirement of the script is as follows:

1. In source directory, if any new files are being dropped by external system then an email should be sent out with a message saying "files are available for further processing".
2. Generate for a string in each *.XML file and get the count of next to each XML file name
format should be:

Code:

XML file name | string occurrence | count (occurrence of string in XML file)

3. if count of string occurrence in XML file is less than 7, should be moved to rejected directory.
4. if count of string occurrence in XML file is equal to 7, should be moved to processed directory.
5. after files are being moved to processed directory, files should be inserted in MYSQL database.
6.final validation, count of XML file name and no.of records which are inserted in MYSQL database should be matched.

Some questions that might help matters along...

1) What mail utilities do you have available to you on the server in question?
2) Is there a single, particular string that you're trying to search for in the XML files? For example, maybe you are always looking for "BINGO", and so could use something like:
$ grep -c BINGO <file>
3) Do you have credentials and table information for the DB?

So, a quick and naive stab at it that might give a starting point for 2-4:

Code:

for file in /dir/ect/ory/*.xml
do
   stringcount=`grep -c BINGO $file`
   if [ "$stringcount" -lt 7 ]
   then
      mv $file /rej/ect/ed
   else
      mv $file /pro/ces/sed
   fi
done

There's no point to attempting #1 without more information about what's available on the server for sending emails. Similarly, we'd need to know about the MySQL DB in order to know about submissions to that.

thanks treeslouth,
need an output in the following format, could you please help me...

example:

Code:

XML File name | list of matching string | count
abc.xml          | abc file                       | 2
                      | xyz file                       |
xyz.xml           | ccc file                       | 1

Moderator's Comments:

CODE tags are crucial to make column alignment visible.

So you mention "list of matching string". Are there multiple strings that you're counting? For example, do you want to know how many times, in total, either "foo" or "bar" appear in an XML file?