Find a string under a directory that is contained in another file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Find a string under a directory that is contained in another file
# 1  
Old 09-17-2008
Find a string under a directory that is contained in another file

Hi I am loking for some help in writing a script that will take a number that is located in one file and search a folder structure for that string in any file under that directory. I can do this manually with :

find /"directory" -type f -exec grep -l 'Number String' {} \;

But now I will have to search for thousdands of numbers. All the number will be in one xls or csv file. I would also like to write all the results to a file so that we can go back and show each file/location that each of those strings hit. I'm sure this is an easy task but I am currently at a loss and any help would be greatly appreciated.
# 2  
Old 09-17-2008
csv file, with numbers only in the fields
Code:
awk -F, '{ for(i=1; i<=NF; i++) {print $i} }' |\
while read number
do
       echo "searching ************************* $number"
       find /"directory" -type f -exec grep -l "$number" {} \;

done  > results.txt

# 3  
Old 09-17-2008
OK so of course after you post something it starts all coming back to you and I came up with this:

find /"directory" -type -f -exec grep -lf /"number file location" {} \; >> /tmp/results.txt

Now my only question is does anyone know a way to include the string that was currently being used with each line of data being sent back. I ran that command and got a list of the files that each of those numbers were in but no way to tell which number matched to which file. Again all help is appreciated.
# 4  
Old 09-17-2008
Jim,

Please excuse my ignorance but where do I put in the file that contains all the numbers in your script.

Thank you
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find string in file and find the all records by string

Hello I would like to get know how to do this: I got a big file (about 1GB) and I need to find a string (for instance by grep ) and then find all records in this file based on a string. Thanks for advice. Martin (12 Replies)
Discussion started by: mape
12 Replies

2. Shell Programming and Scripting

Capture string contained on a line?

Hello All, I'm working on a script that runs the wget command on a list of IP Address in order to capture the data at that address' index.html. That part works fine to get the HTML code at that address but the data I'm trying to pull out is on a line containing a BUNCH of code for an HTML... (4 Replies)
Discussion started by: mrm5102
4 Replies

3. Shell Programming and Scripting

HPUX find string in directory and filetype and replace string

Hi, Here's my dilemma. I need to replace the string Sept_2012 to Oct_2012 in all *config.py files within the current directory and below directories Is this possible? Also I am trying to find all instances of the string Sept_2012 within files in the current directory and below I have... (13 Replies)
Discussion started by: pure_jax
13 Replies

4. AIX

Find the patch that contained a particular file.

Hi All, I have an AIX executable (/usr/bin/shell) in my system. I want to know if this file was updated by any of the installed fixes/apars on my system. What is the AIX way of finding this information? Greetings, Peter (1 Reply)
Discussion started by: petervg
1 Replies

5. UNIX for Dummies Questions & Answers

How to Find a String in Each File in a Directory

Hi, I have the ff. list of files in the dir named /home/joule/unix/archive: $ /home/joule/unix/archive joule1.gz joule2.gz joule3.gz joule4.gz joule5.gz joule6.gz joule7.gz joule8.gz What I would like to do is to find this string in a group of files in the directory above: String to... (1 Reply)
Discussion started by: Joule
1 Replies

6. Shell Programming and Scripting

How to find particular string in multiple files with in the current directory.

Hello friends, Plz suggest the find command, How to search a string in a paticular string in miltiple files with current dirctory.:) Thanks in advance. Siva Ranganath Ch (2 Replies)
Discussion started by: sivaranga001
2 Replies

7. UNIX for Dummies Questions & Answers

Script to find a string in a directory/sub-directory

I'm trying to find this string 'preparing string IBE_Quote_W1_Pvt.SaveWrapper for quote_header_id’ in my Apache log file directory. The log file that contains this string may be in a parent direcotry or a sub-directory. I have tried 'grep' and 'awk' with no success. I would like to get the path... (3 Replies)
Discussion started by: gross
3 Replies

8. Shell Programming and Scripting

find and replace string in a directory files

Hi, I have a directory has DIR1 and the D1 directory has 200+ files. I want change the string from "Bangalore" to "Bangaluru" in all files in the D1 directory. Thanks (2 Replies)
Discussion started by: koti_rama
2 Replies

9. UNIX for Dummies Questions & Answers

Unix find command to print directory and search string

Hi i need to print pathname in which the string present using 'find' command sample output like this Pathname String to be searched ---------- -------------------- /usr/test/myfile get /opt/test/somefile get Thanks in... (4 Replies)
Discussion started by: princein
4 Replies

10. AIX

Help Using Grep command to Find the string in the files in the root directory

I want to serch for a string in all the files in the root directory. i want the search to be limited to only the files in the directory i.e the search to be done only in the files not in the sub directory. the approaches tried are 1)grep "pattern string" this command was serching the... (3 Replies)
Discussion started by: Subbu_Angeline
3 Replies
Login or Register to Ask a Question

Featured Tech Videos