topic Re: Help scripting in Operating System - HP-UX

Help scripting

Vogra — Wed, 04 May 2005 09:46:49 GMT

Hi All!
i have 2 files and i need check one with the contents that exist in another.

lista1.txt and lista2.txt

like this:

for each line in lista1.txt
do
is it equal any line in lista2.txt ?
send line to lista3.txt
done

Thanks,
Lima.

Re: Help scripting

RAC_1 — Wed, 04 May 2005 09:53:59 GMT

for i in $(do
grep -iq "grep_string" file2 > /dev/null 2>&1
if [[ $? -eq 0 ]]
then
echo ${i} >> file3
fi

Also check comm, diff, uniq commands.

comm -12 file1 file2 > file3

Anil

Re: Help scripting

KapilRaj — Wed, 04 May 2005 10:01:27 GMT

cat lista1.txt |while read line
do
grep "$line" lista2.txt >> lista3.txt
done

Kaps

Re: Help scripting

A. Clay Stephenson — Wed, 04 May 2005 10:05:41 GMT

I would leverage the comm comand for this. This should do it:
----------------------------------------
#!/usr/bin/sh

typeset TDIR=${TMPDIR:-/var/tmp}
typeset T1=${TDIR}/T${$}_1.txt
typeset T2=${TDIR}/T${$}_2.txt

typeset PROG=${0##*/}

trap 'eval rm -f ${T1} ${T2}' 0 1 2 15

typeset -i STAT=0
if [[ ${#} -eq 2 ]]
then
typeset F1=${1}
typeset F2=${2}
shift 2
if [[ -r ${F1} && -r ${F2} ]]
then
sort ${F1} > ${T1}
sort ${F2} > ${T2}
comm -12 ${T1} ${T2}
else
echo "Can't read file ${F1} and/or ${F2}." >&2
STAT=254
fi
else
echo "${PROG} requires 2 args" >&2
STAT=255
fi
exit ${STAT}

---------------------------------------

Use it like this:

comm.sh lista1.txt lista2.txt > lista3.txt

Re: Help scripting

Vogra — Wed, 04 May 2005 10:07:19 GMT

thank you so much!

Re: Help scripting

Victor Fridyev — Wed, 04 May 2005 10:14:31 GMT

Lima,
Try this, it works

sort lista1.txt |uniq >l1.txt
sort lista2.txt |uniq >l2.txt
cat l1.txt l2.txt |uniq -c | awk '$1>1 {print}' |cut -f2- " "

HTH

Re: Help scripting

Hein van den Heuvel — Wed, 04 May 2005 11:19:36 GMT

Why not use file 2 as a pattern file?

grep -f lista2.txt lista1.txt > lista3.txt

Example:

$ cat x1
aap
noot
mies
teun
$ cat x2
mies
noot
vuur
$ grep -f x2 x1
noot
mies

hth,
Hein.

Re: Help scripting

Cem Tugrul — Thu, 05 May 2005 09:38:24 GMT

Hi Vogra;

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=754581

i have asked before and found very interesting solutions.

Good Luck;

Re: Help scripting

Nguyen Anh Tien — Fri, 06 May 2005 02:05:52 GMT

I like this simple solution like Kapil solution
cat lista1.txt |while read var
do
grep "$var" lista2.txt >> lista3.txt
done
HTH
tienna

Re: Help scripting

Amit Agarwal_1 — Fri, 06 May 2005 02:19:23 GMT

There is one issue with the above solutions. If there is a duplicate entry in file1, then it goes undetected using grep.

$ cat file1
aaa
bbb
aaa
$ cat file2
aaa
bbb
ccc

The above solution would still show that file2 contains file1,which is incorrcet.

I believe the best solution would be to sort the two files and then use diff.

$ cat compare.sh
sort file1 -o file1.sort
sort file2 -o file2.sort
diff file1.sort file2.sort > /tmp/diffout
grep '^< ' /tmp/diffout
if [ $? -eq 0 ]
then
echo "file1 is not a subset of file2"
else
echo "file1 is subset of file2"
fi

-Amit

Re: Help scripting

Muthukumar_5 — Fri, 06 May 2005 04:16:30 GMT

You can do as,

> lista3.txt
while read line; do

grep $line lista2.txt >> lista3.txt

done < lista1.txt

grep will automatically print if the pattern in available in the file with that pattern.

HTH.