Shell Programming and Scripting

Hi All,

We have main directory called "head"
under this we have several sub directories and under these directories we have sub directories.

My requirement is I have to find the SQL files which are having the string "procedure" under "head" directory and sub directories as well.
And create new directory "procedure" under "head" and move all the files to the new directory.

head/procedure

In the "procedure" directory all the SQL files which contain the string "procedure" should be there.

Please help me.

Thanks.

Sounds like a one off action for me, not a regular repetitive task for a script. Where do you need help?
mkdir to create directory.
grep to look for keywords in files, evtl. with the -r option.
mv to move the files found.

Hi ,

I have tried this but its not working getting error.

Code:

mkdir procedure
find . -name "*.sql"  -exec grep -l 'procedure' {} \; | mv {} /head/procedure

Thanks

Moderator's Comments:

Please use code tags as required by forum rules!

---------- Post updated at 12:48 PM ---------- Previous update was at 12:32 PM ----------

Hi,

Please help me.

Thanks

Moderator's Comments:

Don't bump up posts!

WHAT is not working? WHAT is the error?

Hi,

getting the error

Code:

mv: cannot access {}

Thanks.

Moderator's Comments:

N O - N O N S E N S E : Please use code tags for code and data as required by forum rules!

Building on what you learned from your last thread (How to search for a string in all the files irrespective of directory.?) from suggestions by Scrutinizer and RavinderSingh13, it would seem that the following should come close to doing what you want.

I note that your 1st post in this thread says you're looking for SQL files, but in post #3 in this thread your code is looking for sql files. The following assumes that your files follow the convention used in post #3. In the future, please state your requirements clearly in your first post. Changing requirements with each new post in a thread wastes everyone's time.

In the future, PLEASE tell us what operating system and shell you're using, so volunteers here don't waste their time making suggestions that won't work in your environment. We should not have to search through dozens of your earlier posts to guess at your environment so we can help you each time you start a new thread.

Code:

#!/bin/ksh
head=/absolute/path/to/head

mkdir -p "$head/procedure"
find "$head" \( -type d -name procedure -prune \) -o \
    \(	-type f -name '*.sql' -exec grep -q -F 'procedure' {} \; \
    	-exec mv {} "$head/procedure" \; \)

Obviously, you'll need to change /absolute/path/to/head in the above script to the actual absolute pathname of the head directory you want to use. (You didn't give a pathname for this directory in your first post and the 3rd post in this thread gives conflicting locations for it.)

The {} placeholder has a meaning for the find command alone. After piping find's output to the mv command, the file name found are supplied via stdin. You'll need something to convert stdin to parameters on the command line, xargs.

Code:

find . -name "*.sql"  -exec grep -l 'procedure' {} \; | xargs mv  -t /head/procedure

BUT - this may lead to problems as in file names with white space.