Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need help to grep for a title match and then make some queries after the match

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help to grep for a title match and then make some queries after the match
# 1  
Old 03-22-2010
Need help to grep for a title match and then make some queries after the match
Here is the sample of my file address.txt

Address 1
1234 Drive way
New Orleans, LA
Zipcode :- 12345

Address 2
4567 Spring way
Chicago, IL
Zipcode :- 67890

I would like to grep for an Address title (Ex :- Address 2) , then get its zipcode and echo both in a single line. Ex :- "Address2 Zipcode"

What would be a good way to achieve this?

Note :- The no. of lines below the Address title would be inconsistent, so grepping for a particular number of lines below the title match might not help.

Thanks a lot in advance!!! Smilie
# 2  
Old 03-22-2010
Hi, leo.maveriick, and welcome to the forums.

If "adbook" were the name of the file with the address information, the following AWK should return the zipcode:
Code:
$ awk -v t='Address 2' '$0~t{while (!/Zipcode/) getline; print t,$3; exit}' adbook
Address 2 67890

Where t is the address title you'd like to find.

Regards,
Alister
Last edited by alister; 03-22-2010 at 11:01 PM..
# 3  
Old 03-22-2010
Here's a Perl solution:

Code:
$ 
$ 
$ cat address.txt
Address 1
1234 Drive way
New Orleans, LA
Zipcode :- 12345

Address 2
4567 Spring way
Chicago, IL
Zipcode :- 67890

Address 3
1339 Beverly Hills
Suite # 1290
Los Angeles
CA
Zipcode :- 91602 
$ 
$ 
$ ##
$ perl -lne 'chomp;
             if ($.==1 or $in==1) {$a=$_; $in=0}
             elsif (/^Zipcode :- (\d+)/) {$z=$1}
             elsif (/^\s*$/) {$in=1; print $a," ",$z}
             END {print $a," ",$z}' address.txt
Address 1 12345
Address 2 67890
Address 3 91602
$ 
$

tyler_durden
# 4  
Old 03-24-2010
Thanks guys!!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies

2. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing... (0 Replies)
Discussion started by: cmccabe
0 Replies

3. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

4. Shell Programming and Scripting

Search from 1st match and end 2nd match

I've been looking through the forums for awhile now and looking at the man page for grep and egrep and not seeming to find this scenario so it might not be possible but figured I'd throw it out to get some ideas. I'm looking for a way to search a file for 1st match (example below net self) and... (3 Replies)
Discussion started by: djzah
3 Replies

5. Shell Programming and Scripting

Display match or no match and write a text file to a directory

The below bash connects to a site, downloads a file, searches that file based of user input - could be multiple (all that seems to work). What I am not able to figure out is how to display on the screen match found or no match found" and write a file to a directory (C:\Users\cmccabe\Desktop\wget)... (4 Replies)
Discussion started by: cmccabe
4 Replies

6. Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

not getting anywhere with this an xml file contains multiple clients set up with same tags, different values. I need to parse the file for client foo, and change the value of tag "64bit" from false to true. cat clients.xml <Client type"FIX"> <ClientName>foo</ClientName>... (3 Replies)
Discussion started by: jack.bauer
3 Replies

7. UNIX for Dummies Questions & Answers

awk display the match and 2 lines after the match is found.

Hello, can someone help me how to find a word and 2 lines after it and then send the output to another file. For example, here is myfile1.txt. I want to search for "Error" and 2 lines below it and send it to myfile2.txt I tried with grep -A but it's not supported on my system. I tried with awk,... (4 Replies)
Discussion started by: eurouno
4 Replies

8. Shell Programming and Scripting

exact string match ; search and print match

I am trying to match a pattern exactly in a shell script. I have tried two methods awk '/\<mpath${CURR_MP}\>/{print $1 $2}' multipath perl -ne '/\bmpath${CURR_MP}\b/ and print' /var/tmp/multipath Both these methods require that I use the escape character. I am guessing that is why... (8 Replies)
Discussion started by: bash_in_my_head
8 Replies

9. AIX

How to make grep stop at first match

I use grep to check for a string that validates data in a file, it works great but the problem is that the file is becoming too big and gerp has started hurting the response time to users. Since I only need to find the first occurrence I have been looking for ways to stop grep for scanning the rest... (8 Replies)
Discussion started by: mpoblete
8 Replies

10. HP-UX

Need to make disk device files match

Hi, I was wondering if there was a way to change the disk device files ex. /dev/dsk/cxtxd0 ? What I have are two HPUX 11.0 servers using MC Service Guard 11.13. A consultant attached a SAN and both servers had created the same identical LUN device files. Now I could begin creating my volume... (0 Replies)
Discussion started by: mvizza
0 Replies
Login or Register to Ask a Question