Search for string and display those NOT found


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search for string and display those NOT found
# 8  
Old 05-21-2007
Create the file not_found (or other name of your choice) containing the awk program.
Make the file executable : chmod +rx not_found
Execute :
Code:
not_found /home/padlist $(find . -type f)

This command display all the strings from /home/padlist that have not been found in any of the files of curent directory and sub-directories.

Jean-Pierre.
# 9  
Old 05-21-2007
Hi.
Quote:
Originally Posted by John Rihn
...
Here is what my input file format looks like for 4 lines. It's called padlist.

CL1ACC01,"-13181,-32907"
CL1AN01,"-8077,-12652"
CL1CP01,"-13181,4"
CL1FTP01,"-2200,0"

My script is:

exec < /home/padlist
while read d1 d2
do
find . -type f -print | xargs grep $d1 | more
done

So the about displays the full line from the file where $d1 was found. I just need to know what strings were not found.
What is the purpose of d2? And, do you intend to search for the entire string, CL1ACC01,"-13181,-32907", for example, including quotes?... cheers, drl
# 10  
Old 05-21-2007
No, I just plan to search for the 1st set of characters up to the 1st coma. So really I only need the CLxxxxxx info. I've tried Jean-Pierre's method and for some reason it returns nothing, even with a search string I know it won't find. Otherwise I get no errors when I run it.

John
# 11  
Old 05-21-2007
Hi, John.

My perl program, and I think aigles' awk program will read entire lines from padlist as the patterns.

So either we will need to adjust our programs or provide a preliminary step to extract the text up to (and not including) the first comma.

This is an important lesson in communicating requirements. For the future, it is best to provide a sample input and expected output. Even if the data is fake or trivial, we would been able to see more clearly what you wanted. This is also what ghostdog74 was getting at with his question.

You didn't answer my question about "d2" in your script ... cheers, drl
# 12  
Old 05-21-2007
DRL,
Sorry I did not answer your question about d2. I had intended to use comas as a delimiter for a read and just prior to your last post did I realize the awk program would use the entire line for the search string. But I still cannot get it to work for me. So I'll just keep at it.

John
# 13  
Old 05-21-2007
My awk program assumes space as Input Field Separator for the first file.
To use comma separator modify the program :
Code:
#!/usr/bin/awk  -f

#
# Initialize input Field Separator
#

BEGIN {
   FS = ","
}

#
# Strings file.
#

An example:
Strings file: strings.txt
Code:
lulu,xxx
bob,xxx
albert,xxx
gerald,xxx

Input files : Test/*.txt
Code:
Test/bob.txt: bob
Test/john.txt: john
Test/lulu.txt: lulu
Test/toto.txt: toto

Execution:
Code:
$ not_found strings.txt Test/*.txt
albert
gerald
$

If nawk is available on your system, replace awk by nawk in the first line of the program.


Jean-Pierre.

Last edited by aigles; 05-21-2007 at 05:39 PM..
# 14  
Old 05-21-2007
Jean-Pierre,
It's still not working for me. Here is what I have.

String file: D43E6309_padlist

CL123456 xxx
CL1ACC01 xxx
CL1ACF01 xxx

Input files: Too many and too big to show here.

awk program: compare_die2

#!/usr/bin/awk -f
# Filename: compare_die2
#
# String file
#
NR==FNR {
string_found[$1] = 0; # 0 = No, >0 = Yes
next;
}
#
# New data file
# Build array with strings not yet found
#
FNR==1 {
for (str in string_found) {
if (string_found[str] == 0) {
strings[str]++;
strings_count++;
}
}
if (strings_count == 0) exit;
}
#
# Input data
# Search data for strings not yet found
#
{
for (str in strings) {
if ($0 ~ str) {
string_found[str]++;
delete strings[str];
if (--strings_count == 0) exit;
}
}
}
#
# No more files or allstrings have been found
# Print strings not found
#
END {
for (str in strings_found)
if (string_found[str] == 0) print str;
}


I did a chmod 777 compare2_die. Here is the line I executed.

/home/rihnj/compare_die2 /home/rihnj/D43E6309_padlist $(find . -type f) > strings_not_found

Do you see what I've coded wrong or missed? strings_not_found file always comes up empty. The CL123456 search string is not to be found anywhere in directories where the search is being done.

Thanks, John
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search string in multiple files and display column wise

I have 3 files. Each of those files have the same number of records, however certain records have different values. I would like to grep the field in ALL 3 files and display the output with only the differences in column wise and if possible line number File1 Name = Joe Age = 33... (3 Replies)
Discussion started by: sidnow
3 Replies

2. Shell Programming and Scripting

Bash to search file for string and lauch function if found

In the bash below I am searching the filevirus-scan.log for the Infected files: 0 line (in bold) and each line for OK. If both of these are true then the function execute is automatically called and processing starts. If both these conditions are not meet then the line in the file is sent to the... (2 Replies)
Discussion started by: cmccabe
2 Replies

3. UNIX for Beginners Questions & Answers

Search a string and display its location on the entire string and make a text file

I want to search a small string in a large string and find the locations of the string. For this I used grep "string" -ob <file name where the large string is stored>. Now this gives me the locations of that string. Now how do I store these locations in a text file. Please use CODE tags as... (7 Replies)
Discussion started by: ANKIT ROY
7 Replies

4. Shell Programming and Scripting

Search for a tag and display a message if not found.

Hi All, I am working with a XML file. Below is part for the file. <Emp:Profile> <Emp:Description>Admin</Emp:Description> <Emp:Id>12347</Emp:Id> </Emp:Profile> <Emp:Profile> ... (7 Replies)
Discussion started by: Girish19
7 Replies

5. Shell Programming and Scripting

bash: need to have egrep to return a text string if the search pattern has NOT been found

Hello all, after spending hours of searching the web I decided to create an account here. This is my first post and I hope one of the experts can help. I need to resolve a grep / sed / xargs / awk problem. My input file is just like this: ----------------------------------... (6 Replies)
Discussion started by: bash4ever
6 Replies

6. Shell Programming and Scripting

Print lines after the search string until blank line is found

All I want is to look for the pattern in the file...If I found it at # places... I want print lines after those pattern(line) until I find a blank line. Log EXAMPLE : MT:Exception caught The following Numbers were affected: 1234 2345 2346 Error java.lang.InternalError:... (3 Replies)
Discussion started by: prash184u
3 Replies

7. Shell Programming and Scripting

Search a String and display only word.

Hello Gurus, Apologies if this Q has been repeated but i was not able to find it :( I have an input file: ------------------------------- Replace DB.Employee as select column1 column2 from DB_T.Emp and DB.Test and DB.Dept and DB_T.Ter; ------------------------ (4 Replies)
Discussion started by: indrajit_u
4 Replies

8. UNIX for Advanced & Expert Users

Parsing String, Search then display rows

Get occurence of "open" considering duplicates(get the last open). Once you are pointing to the last open count 2 rows to get the correct data. Every begin and end statement, there is a "close" and "open". There can be many "close" and "open" within the begin and end statement but we are... (9 Replies)
Discussion started by: buddyme
9 Replies

9. Shell Programming and Scripting

Display only found string

Is there a way for grep to output only the found string and not the whole line? I have a ksh script which reads in a file and loops through every line looking up on a grep -f list. For it to only display only the string found i pass this to awk as a variable and loop through the list file using... (5 Replies)
Discussion started by: Cranie
5 Replies

10. Shell Programming and Scripting

Recursive Search and replace only when found string

Hello all ( again ) I will like to search and replace string in text file ok I can loop throw the files like : foreach f ( ` find . -name "*."`) .. but here I like to examine the file if in contain the desired string and so do the sed -e 's/blah/foo/g' thingy on it or there is better way... (1 Reply)
Discussion started by: umen
1 Replies
Login or Register to Ask a Question