Searching in another file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Searching in another file
# 1  
Old 05-24-2010
Searching in another file

Hi ALL,

I need to search the contents present in one file with another file.

File 1
Code:
David E0001 
Suresh E0002

File 2
Code:
David
  company - ETL
Suresh
  company - ELT
Venkat
  company - EET

I need to print company name from File 2 for the list of names available in File 1. I need your guidance to resolve this as i am new to UNIX.
Thanks in advance.

Last edited by radoulov; 05-24-2010 at 09:57 AM.. Reason: Added code tags!
# 2  
Old 05-24-2010
I see you've been new to unix for two years. Write a script to read each line in file one into two variables, name and number, then grep file 2 for the existence of name.
You will probably find it easier if name and company are on the same line in file 2.
Take into consideration that there may be multiple answers to the search.
# 3  
Old 05-24-2010
You can do something like that :
Code:
awk '
NR==FNR { name=$1 ; getline ; company[name]=$3 ; next }
{ print $0,company[$1] }
' sekar2.txt sekar1.txt

Output:
Code:
David E0001  ETL
Suresh E0002 ELT

Jean-Pierre.
# 4  
Old 05-25-2010
Hi,

Thanks. i tried your code, but it display contents from both file. I tried up myself to first find the number of lines in the file1 and thinking of storing the values in array and perform the search in fiel 2.
Code:
targetfile1="/apps/file1.txt"
targetfile2="/apps/file2.txt"
i=echo `sed -n '$=' "$targetfile1"`
echo $i >> $targetfile

The above code is not working. please guide me.
# 5  
Old 05-25-2010
Quote:
Originally Posted by Sekar1
Hi,

Thanks. i tried your code, but it display contents from both file. I tried up myself to first find the number of lines in the file1 and thinking of storing the values in array and perform the search in fiel 2.
Code:
targetfile1="/apps/file1.txt"
targetfile2="/apps/file2.txt"
i=echo `sed -n '$=' "$targetfile1"`
echo $i >> $targetfile

The above code is not working. please guide me.
What output do you expect from your sample data ?

Jean-Pierre.
# 6  
Old 05-25-2010
Sekar1,
how should the output exactly look like?
# 7  
Old 05-26-2010
Hi ,
pls find my code

Code:
targetfile="/apps/file.txt"
targetfile1="/apps/file1.txt"
atxt="/apps/a.txt"
totalrecs=`sed -n $= $targetfile1`
tot=1
cat $targetfile1 | while read c_line
do
ARRAY14[$tot]=`echo "$c_line"`
tot=$i+1
done
fet=1
while [ $fet -le $tot ]
do
l=`echo $(grep -n $ARRAY14[$fet] "$atxt" | cut -d":" -f1)`
i=$l-2
j=$l+10
sed -n "$j"p filename
sed -n "$i"p filename
fet=$fet+1
done

I have 2 files. "file.txt" holds the string to be searched in "file1.txt". so i stored the values into array and performed the seach in file1.txt. once the string is found, i need to extract 2nd above the matched string and 10th line below the matched string. pls correct the mistake which i did in the code and give me updates.
Thanks in advance.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Searching the content of one file using the search key of another file

I have two files: file 1: hello.com neo.com,japan.com,example.com news.net xyz.com, telecom.net, highlands.net, software.com example2.com earth.net, abc.gov.uk file 2: neo.com example.com abc.gov.uk file 2 are the search keys to search in file 1 if any of the search key is... (3 Replies)
Discussion started by: csim_mohan
3 Replies

2. UNIX for Dummies Questions & Answers

Searching for a file...

Hi guys... Macbook Pro, OSX 10.7.5, bash... I want to search for a known file in a totally unknown location. This works perfectly:- capturepath=`find / -name 'sox' 2>/dev/null` Except it is crucyfyingly SSLLOOWW; and I mean SSLLOOWW! Is there any means of searching the entire FS quickly... (5 Replies)
Discussion started by: wisecracker
5 Replies

3. Shell Programming and Scripting

Searching a file inside a .tar.gz file by date

Hi, I would like to ask if there is a way to search for a file inside a .tar.gz file without extracting it? If there is, is there a way to search for that file by date? Thanks! (4 Replies)
Discussion started by: erin00
4 Replies

4. Shell Programming and Scripting

Searching file for pattern, output to file (BASH)

Hello, I'm trying to write a script in Bash to assist in pentesting. Essentially I'm looking to use a script to search for some terms in a log file and then send that key information into another file. The log files consist of HTTP and SSL information that someone creates while browsing and... (2 Replies)
Discussion started by: Sagesparten007
2 Replies

5. Shell Programming and Scripting

searching a file with a specified text without using conventional file searching commands

without using conventional file searching commands like find etc, is it possible to locate a file if i just know that the file that i'm searching for contains a particular text like "Hello world" or something? (5 Replies)
Discussion started by: arindamlive
5 Replies

6. Shell Programming and Scripting

Help in searching a particular string in a file name (not inside the file contents)

Dear Unix Gurus, I am new to shell scripting and in the process of learing. I am trying to find whether a file name has today's date in MMDDYYYY format. I am using the following code and it doesn't seem like working. #!/usr/bin/ksh today=$(date '+%m%d%Y') echo today: $today file=`find... (4 Replies)
Discussion started by: shankar1dada
4 Replies

7. UNIX for Dummies Questions & Answers

Help with searching for a file in a directory and copying the contents of that file in a new file

Hi guys, I am a newbie here :wall: I need a script that can search for a file in a directory and copy the contents of that file in a new file. Please help me. :confused: Thanks in advance~ (6 Replies)
Discussion started by: zel2zel
6 Replies

8. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Need to develop a unix shell script for the below requirement and I need your assistance: 1) search for file.log and file.bad file in a directory and read them 2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file 4) concatinate each row from bad file as... (3 Replies)
Discussion started by: mlpathir
3 Replies

9. Shell Programming and Scripting

searching a log file and appending to a .txt file

I'm new to shell scripting and am writing a script to help me log the free memory and hd space on a server. As of now, the script just runs 'df -h' and appends the output to a file and then runs 'top' and appends the output to a log file. What I want to do, is have the script also search the... (3 Replies)
Discussion started by: enator45
3 Replies

10. Shell Programming and Scripting

Append a field to the end of each line of a file based on searching another file.

Hi All, I have two comma separated value(CSV) files, say FileA and FileB. The contents looks like that shown below. FileA EmpNo,Name,Age,Sex, 1000,ABC,23,M, 1001,DES,24,F, ... (2 Replies)
Discussion started by: ultimate
2 Replies
Login or Register to Ask a Question