Visit Our UNIX and Linux User Community


Grep? - using a file of terms to search another file when the information is on a different line


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Grep? - using a file of terms to search another file when the information is on a different line
# 1  
Old 08-14-2013
Grep? - using a file of terms to search another file when the information is on a different line

I have a flat file that looks like this, let's call it Chromosome_9.txt:
Code:
FT                   /Gene_Name="Guanyl-Acetylase 9"
FT                   /Gene_Number"36952"
FT                   /Gene_Name="Endoplasmic Luciferase"
FT                   /Gene_Number"36953"
FT                   /Gene_Name="Variant Antigen Protein 12"
FT                   /Gene_Number"36954"
FT                   /Gene_Name="Acyl-CoA Synthetase 11"
FT                   /Gene_Number"36955"
FT                   /Gene_Name="Conserved protein, unknown function"
FT                   /Gene_Number"36956"

This is a file in a specialized format that contains all the information about genes on a chromosome, including the names and associated numbers. What I have is a list of numbers ("/Gene_Number," above), like this, let's call it gene_names.txt:
Code:
2568
3658
9567
23657
63654
76532

but I need the names associated with those numbers (on the line above the number in the file). This would be trivial is they were on the same line because then I could use:
Code:
grep -f gene_names.txt Chromosome_9.txt

Because the search term and the actual information I am looking for are on different lines, I am not sure what to do.

Thanks!
# 2  
Old 08-14-2013
Does your grep support the -B option?
# 3  
Old 08-14-2013
It does, but I don't know how to combine -f with -B
# 4  
Old 08-14-2013
Code:
grep -B1 -f ...

This User Gave Thanks to Scott For This Post:
# 5  
Old 08-14-2013
Thanks, worked like a charm
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #171
Difficulty: Medium
IBM acquired Red Hat for $34 billion USD.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Search for the information at file

I'm having few question. i'm have a input file. Other information CONNECTIONS "BP-COLLECTOR" J6.4 "BP-TEST".4; +5VS C34.1 U21.1; DEV_I2C_SDA J6.6 R4.1 U18.1; DEVICES "BP-TEST" 1."BP-LED_ANODE" (8 Replies)
Discussion started by: kttan
8 Replies

2. Shell Programming and Scripting

Perl to extract information from a file line by line

In the below perl code I am using tags within each line to extract certain information. The tags that are used are: STB >0.8 is STRAND BIAS otherwise GOOD FDP is the second number GO towards the end of the line is read into an array and the value returned is outputed, in the first line that... (1 Reply)
Discussion started by: cmccabe
1 Replies

3. UNIX for Dummies Questions & Answers

Search file and print everything except multiple search terms

I'm trying to find a way to search a range of similar words in a file. I tried using sed but can't get it right:sed 's/\(ca01\)*//'It only removes "ca01" but leaves the rest of the word. I still want the rest of the information on the lines just not these specific words listed below. Any... (3 Replies)
Discussion started by: seekryts15
3 Replies

4. UNIX for Dummies Questions & Answers

Grep -B used with -f? (Searching a file using a list of terms, output is lines before each match)

(1 Reply)
Discussion started by: Twinklefingers
1 Replies

5. UNIX for Dummies Questions & Answers

Obtaining File information based on String Search

Is there a single Command in Unix to get the following Information when searching for files containing one or more strings in a Unix Directory (including sub directories within it) : 1) Complete filename ( path and filename) 2) Owner of the file 3) Size of the file 4) Last Modified date... (3 Replies)
Discussion started by: pchegoor
3 Replies

6. Shell Programming and Scripting

Grep multiple search terms with context

I have a file that is a sort library in the format: ##def title1 content1 stuff1 content2 stuff2 ##enddef ##def title2 etc.. I want to grep def and content and pull some trailing context from content so the result would look something like: (1 Reply)
Discussion started by: Moe.Wilensky
1 Replies

7. Shell Programming and Scripting

Grep'ing information from a log file on SUN OS 5

Hi Guys, I'm trying to write an script that will be launched by a user. The script will look at a log file and check for alerts with the date (supplied by user) and a machine's hostname (also supplied by the user). I'm trying to get the output formatted just like the log file. The logfile looks... (5 Replies)
Discussion started by: illgetit
5 Replies

8. Shell Programming and Scripting

Find common terms in two text file, xargs, grep

Hello, I'm interested in finding all occurrences of the terms in file1 in file2, which are both csv files. I can do this with a loop but I'm interested in knowing if I can also do it with the help of xargs and grep. What I have tried: cat file1 | xargs grep file2 The problem is that... (15 Replies)
Discussion started by: eon
15 Replies

9. Shell Programming and Scripting

copying file information using awk & grep

Hi, TASK 1: I have been using this code to print the information of files kept at "/castor/cern.ch/user/s/sudha/forPooja" in some text file name FILE.txt. rfdir /castor/cern.ch/user/s/sudha/forPooja | grep data | awk '{print "rfio:///castor/cern.ch/user/s/sudha/forPooja/"$9}' > FILE.txt ... (6 Replies)
Discussion started by: nrjrasaxena
6 Replies

10. Shell Programming and Scripting

Script to search a large file with a list of terms in another file

Hi- I am trying to search a large file with a number of different search terms that are listed one per line in 3 different files. Most importantly I need to be able to do a case insensitive search. I have tried just using egrep -f but it doesn't seam to be able to handle the -i option when... (3 Replies)
Discussion started by: dougzilla
3 Replies

Featured Tech Videos