hi!

i have 3 text files with different patterns.
(actualy they are lists of files in different formats)

what i need to do is write script that produces a report that shows if the pattern is found in all 3 files.

for example:
PATTERN : file1 : file2 : file3
-----------------------
MONSTER : YES : YES : YES
MASTER : NO : NO : YES
SLAVE : YES : YES : NO
.........

i can retrieve list of patterns from each file with:
cat file1.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}'

cat file2.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}'

cat file3.txt | grep -v \# | awk 'BEGIN { FS = "/" } { print $4}'

but how can i put all this together to make report?

Can you put some samples of the original 3 input files and what exactly the output is required ?

This will make it easier for us to give some sort of suggestions..

Regards,
Devaraj Takhellambam

this is a bit long but it will work.

cat file1.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}' > infile

cat file2.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}' >> infile

cat file3.txt | grep -v \# | awk 'BEGIN { FS = "/" } { print $4}' >>infile

sort -u infile > outfile

#!/bin/ksh
echo "PATTERN:File1:File2:Fil3"
while read line
do
if [ `grep -c "$line" file1` -gt 0 ]
then
echo "$line:Yes:---"
else
echo "$line:No:---"
fi
if [ `grep -c "$line" file2` -gt 0 ]
then
echo "-----:Yes:---"
else
echo "-----:No:---"
fi
if [ `grep -c "$line" file3` -gt 0 ]
then
echo "-----:---:Yes"
else
echo "-----:---:No"
fi
done < "outfile"

PS: you have to work around a bit on the formatting of the output.

cheers,
Devaraj Takhellambam

Regards,
Devaraj Takhellambam

cat file1.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}' > infile

cat file2.txt | grep -v "\*\:\|\#" | awk 'BEGIN { FS = ":" } { print $1}' >> infile

cat file3.txt | grep -v \# | awk 'BEGIN { FS = "/" } { print $4}' >>infile

sort -u infile > outfile

echo "PATTERN:File1:File2:Fil3"
while read line
do
if [ `grep -c "$line" file1` -gt 0 ]
then
var1="Yes"
else
var1="No"
fi
if [ `grep -c "$line" file2` -gt 0 ]
then
var2="Yes"
else
var2="No"
fi
if [ `grep -c "$line" file3` -gt 0 ]
then
var3="Yes"
else
var3="No"
fi
echo "$line:$var1:$var2:$var3"
done < "outfile"

RESULT:
PATTERN:File1:File2:Fil3
MASTER:Yes:Yes:No
MONSTER:Yes:No:No
NICE:Yes:Yes:No
NSTER:Yes:No:No
SLAVE:Yes:Yes:Yes
TEMP:No:No:Yes
TEST:Yes:Yes:Yes

Regards,
Devaraj Takhellambam

i tried response #3
it works!

thanks a lot Deravaj!