topic Re: Find strings in files in Operating System - HP-UX

Find strings in files

Mauro_8 — Mon, 04 Aug 2003 13:50:14 GMT

Hi,

I listed all tables of my databse to a file called tables.txt each table in one line and I want to know if these database tables are used in some source code. These source codes are under /tmp/source/dir_1, /tmp/source/dir__2 ... /tmp/source/dir_n. I used:

find /tmp/source -depth -print > find.log, to list all files under /tmp/source and it worked fine.

then I did:
egrep -i -n -f tables.txt find.log, to list the files that have one of my database tables in it.

But I do not know the table that is used because doing these commands I only know that one of the tables is present in the source code file listed but what table ? I really want to list the tables in tables.txt file that is used in one of the source code files.

Any ideas of how can I do it ?

Cheers,
Mauro

Re: Find strings in files

curt larson_1 — Mon, 04 Aug 2003 14:00:08 GMT

a short script should work

cat find.log |
while read file
do
egrep -f tables.txt $file 1>/dev/null 2>&1
if [ $? = 0 ] ;then
print $file
fi
done

Re: Find strings in files

Steven E. Protter — Mon, 04 Aug 2003 14:03:09 GMT

find /ias -exec grep -l '/oracle/ias/product' {} \;

Change as needed.

SEP

Re: Find strings in files

curt larson_1 — Mon, 04 Aug 2003 14:05:35 GMT

guess i should read your requirements better
> I really want to list the tables in tables.txt file that is used

how about this:

cat find.log |
while read file
do
egrep -f tables.txt $file 1>/dev/null 2>&1
if [ $? = 0 ] ;then
print "\nTables in $file:\n"
egrep -f tables.txt $file
fi
done

Re: Find strings in files

Elena Leontieva — Mon, 04 Aug 2003 15:13:17 GMT

Mauro,

1. You can simply go to each dir_1, dir_2 etc., i.e. cd /tmp/source/dir_1 and run a command:

egrep -f tables.txt *

2. find /tmp/source -depth -print -exec egrep -f tables.txt {} \; |more , but this will also list all the files under /tmp/source.

Elena.

Re: Find strings in files

vasundhara — Tue, 05 Aug 2003 10:20:53 GMT

Hi,

Another way to find...

cd /tmp/source
for table in `cat tables.txt`
do
find . -type f | xargs grep $table
done

you have to give absolute path of tables.txt

Regards
VJ.