Find, grep and amend

[Declan Heerey]

I have several directories containing several files. What i want to go is recursively grep a string from these files and manipulate it.

I.e. i want to grep for all instances of CREATE TABLE chop the different and create a grants file i.e.

GRANT SELECT ON to
GRANT SELECT ON to
.......

Any quick ways to achieve this?

Thanks in advance

Declan

[TwoProc · Accepted solution]

Something like this... ?
Put this in a file, then make it executable, then run it.
Need to change the names of the directories for the find command.
Need to change the name of SOMEUSER.

#!/bin/ksh
find /dir1 /dir2 /dir2 -type f -name "*.sql" -exec grep -i "CREATE TABLE" {} \; > /var/tmp/mylist.$$
cat /var/tmp/mylist.$$ | awk '{ print "GRANT SELECT ON " $3 " TO SOMEUSER " }' > grant_list.sql
rm /var/tmp/mylist.$$

[RAC_1]

Goto the dir, you want to search.
Does this grep line has fixed position for word?? (Auusming 3 rd position on the line)

find . -type f -print | while read LINE
grep -q "CREATE TABLE" ${LINE}
if [[ $? -eq 0 ]];then
grep "CREATE TABLE" $LINE |awk '{print "GRANT SELECT ON", $3, "to", "user"}' >> /tmp/somefile 2>/dev/null
done

Anil

[Declan Heerey]

Cheers, both work a treat.