Shell Programming and Scripting

I have absolutely no idea how to do this and everything I have done doesn't even come close.

Here's the scenario:

There are a number of files in a folder named in this manner:

agd.txt
stv.txt
frk.txt
dqp.txt

There is also a series of other files in the same folder with like file names but with a .doc extension. The catch here is that most but not all .txt files have a corresponding .doc file.

agd.doc
stv.doc
dqp.doc

What has to happen here is that each .doc file has to be scanned for specific lines that contain a word. Let's use "rabbit" as an example. It may be in the form of rabbit, rabbits, _rabbit, xxxrabittxyz, RABBIT, Rabbit, etc.

If any lines in agd.doc contain rabbit, in any form, those specific lines need to be appended to the bottom of the agd.txt.

This has to happen for each matching .doc and .txt file.

If there is a frk.txt but no frk.doc or a frk.doc but no frk.txt then nothing is to be processed for that particular file name.

Once a .doc file has been tested and the corresponding .txt file has been appended the .doc file needs to be deleted, even if rabbit was not found in the .doc. At the end of the routine the only .doc files that should be left are those that did not have a matching .txt file to append to.

please try and see if it's ok since no test on you data:

Code:

for i in `ls *.doc| sed 's/.doc//'`
do
  if [ -f $i.txt ]
  then
   awk 'NR==FNR && /rabbit/ {a=a"\n"$0} NR!=FNR {print FNR==1?a"\n"$0:$0}' $i.doc $i.txt >tmp
   cat tmp >$i.txt
   rm $i.doc tmp
  fi
done

note: before you run it, please have you data get a copy

lets see if this helps.
first how do I know the "word like rabbit" ??
I will assume that we have a file with the key word in it 1 per line.

Code:

for y in `ls -1 *.doc`
 do
        b_name=`basename $y .doc`
        if [ -f $b_name.txt ]; then
            egrep -f <file of key words> -i $y >> $b_name.txt
        fi
done

yinyuemi ,

I have tested your script and it works as desired except that it places the lines before the first line of the target file. I need the lines inserted after the last line of the file.

try:

Code:

for i in `ls *.doc| sed 's/.doc//'`
do
  if [ -f $i.txt ]
  then
   awk 'NR==FNR && /rabbit/ {a=a"\n"$0} NR!=FNR {print $0}END{print a}' $i.doc $i.txt >tmp
   cat tmp >$i.txt
   rm $i.doc tmp
  fi
done

yinyuemi,

Okay, your second script performs correctly and places the lines below the current last line in the target file. Now I will research your script and figure out what everything does so I can learn from it. Thank you very much for your help.




aix-guy,

Concerning your script .... am I to assume <file of key words> is a file I create with a list of words and if any of those words are found in a line that line gets appended to the .txt file? I ask because I am not getting your script to do anything and I do have a file that lists rabbit as a word to be found.