Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Multiple search pattern

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Multiple search pattern
# 1  
Old 04-02-2013
Multiple search pattern
Hello Smilie
I have this file


cat employee_list
Name : jack
Gender: m
ID : 4512
DOB : 03/27/1980
hire date : 04/23/2012
Nationality: US
marital status : single
=====================
Name : mick
Gender: m
ID : 1256
DOB : 03/27/1970
Hire date : 012/10/2011
Nationality: US
Marital status : married
=====================
Name : jolly
Gender: F
ID : 14523
DOB : 03/27/1970
Hire date : 01/20/2009
Nationality: US
Marital status : married
=====================


can you please help me to use awk to extract a list of ID with Hire date and gender


output example
4512 M 04/23/2012
1256 M 012/10/2011
14523 F 01/20/2009

Thanks,
Sara
Last edited by Sara_84; 04-02-2013 at 04:55 AM..
# 2  
Old 04-02-2013
Code:
awk '/Gender/{g=$NF}/ID/{id=$NF}/[Hh]ire/{print id,g,$NF}' input_file

--ahamed
Last edited by ahamed101; 04-02-2013 at 05:14 AM..
# 3  
Old 04-02-2013
Quote:
Originally Posted by ahamed101
Code:
awk '/Gender/{g=$NF}/ID/{id=$NF}/[Hh]ire/{print id,g,$NF}' input_file

--ahamed
Thanks Ahamed
one problem , i fogot one thing, hire date line ends with time
i want to print only the date , $NF will print the time not date
Hire date : 01/20/2009 10:00
# 4  
Old 04-02-2013
Use NF-1 in-place of NF:

Code:
awk '/Gender/{g=$NF}/ID/{id=$NF}/[Hh]ire/{print id,g,$(NF-1)}' file

Guru.
This User Gave Thanks to guruprasadpr For This Post:
Sara_84
# 5  
Old 04-02-2013
Another awk
Code:
awk '/Gender/ {g=$NF;getline;i=$NF;getline;getline;print i,g,$4}' file
4512 m 04/23/2012
1256 m 012/10/2011
14523 F 01/20/2009

This User Gave Thanks to Jotne For This Post:
Sara_84
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pattern search multiple files

#!/usr/bin/ksh a="Run successfully" cd $APPS ls -l *.txt | while read $txt do if then cp $APPS/$txt cp $hist/$txt else rm $APPS/$txt echo "Files has been removed" fi done New in shell script please help me out Around 100 txt files in $APPS dir i want to search pattern from... (8 Replies)
Discussion started by: Kalia
8 Replies

2. Shell Programming and Scripting

Search multiple pattern in a file

I have a sample file with following output: HTTP/1.1 200 OK User: admin Set-Cookie: AMBARISESSIONID=y3v3648yqcno32nq478kw7ar;Path=/;HttpOnly Expires: Thu, 01 Jan 1970 00:00:00 GMT Content-Type: text/plain Vary: Accept-Encoding, User-Agent Content-Length: 6057 Server:... (4 Replies)
Discussion started by: saurau
4 Replies

3. Linux

Search multiple pattern from list

I am working on AIX operating system. I want to search list of Article Id for given Set Date (which are present in a seperate file input.txt) art_list.csv ------------ "Article ID" |"Ad Description" |"Pyramid"|"Pyramid Desc "|"ProductTypeId"|"Set Date "|... (3 Replies)
Discussion started by: rajivrsk
3 Replies

4. Shell Programming and Scripting

awk with multiple pattern search

Want to fetch a column with multiple pattern using awk. How to achieve the same. Tried cat test address : 10.63.20.92/24 address : 10.64.22.93/24 address : 10.53.40.91/24 cat test | awk '{print $3}' |awk -F "/" '{print $1}' 10.63.20.92 10.64.22.93 10.53.40.91 Is there any... (2 Replies)
Discussion started by: Manasa Pradeep
2 Replies

5. Homework & Coursework Questions

sed Multiple Pattern search and delete the line

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I have file which has got the following content sam 123 LD 41 sam 234 kp sam LD 41 kam pu sam LD 61 Now... (1 Reply)
Discussion started by: muchyog
1 Replies

6. Shell Programming and Scripting

Help need with PERL multiple search pattern matching!

My example file is as given below: conn=1 uid=oracle conn=2 uid=db2 conn=3 uid=oracle conn=4 uid=hash conn=5 uid=skher conn=6 uid=oracle conn=7 uid=mpalkar conn=8 uid=anarke conn=9 uid=oracle conn=1 op=-1 msgId=-1 - fd=104 slot=104 LDAPS connection from 10.10.5.6 to 10.18.6.5 conn=2... (3 Replies)
Discussion started by: sags007_99
3 Replies

7. Shell Programming and Scripting

Multiple pattern search in perl

user 10 values content is: musage.py yes value user 11 values content is: gusage.py yes value how to print "user" string line by searching "content is:" string and "usage.py" string in perl (8 Replies)
Discussion started by: Anjan1
8 Replies

8. Shell Programming and Scripting

pattern search for multiple log files and counting

I have 10 appservers and each appserver has 4 jvms . Each of these logs is archived and stored on a nfs directory . For example the files are /logs/200907/ap1-jvm1.server.log.20090715.gz /logs/200907/ap2-jvm2.server.log.20090714.gz /logs/200908/ap1-jvm1.server.log.20090812.gz I want to... (3 Replies)
Discussion started by: gubbu
3 Replies

9. Shell Programming and Scripting

Pattern search in multiple lines

Hi, I have to search those statements from the file which starts from "shanky"(only shanky, shanky09 or 09shanky is not allowed) and ends with ");". These two string can be in a same line or different line. And also i have to negate those lines which starts with #. Can any one please give me... (2 Replies)
Discussion started by: shanky09
2 Replies
Login or Register to Ask a Question