Searching for exact match using grep


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Searching for exact match using grep
# 1  
Old 01-17-2014
Searching for exact match using grep

I am searching for an exact match on a value read from another file to lookup an email address in another file. The file being checked is called "contacts" and it has Act #, email address, and contact person.
Code:
1693;abc1693@yahoo.comt;Tommy D
6423;abc6423@yahoo.comt;Jim Doran
6491;abc6491@gamil.comdt;Snowden
155;xyz155@gmail.com; Lenny Melfi
442;xyz422@test.com; Tommy Davis
2155;abc2155@google.com; Cindy F

Code:
email=`grep $acc /u/star/contacts|cut -f2 -d';'`

The results give me 155 and 2155 and I only want to get 155 as a match so I get email = xyz155@gamail.com and email = abx2155@google.com. Any suggestions on how to get only 155?

Last edited by Scott; 01-17-2014 at 12:31 PM.. Reason: Please use code tags for code blocks
# 2  
Old 01-17-2014
You may try awk

Code:
$ awk -F";" '$1==search{print $2}' search="155" file
xyz155@gmail.com
akshay@Aix:/tmp$ cat a
1693;abc1693@yahoo.comt;Tommy D
6423;abc6423@yahoo.comt;Jim Doran
6491;abc6491@gamil.comdt;Snowden
155;xyz155@gmail.com; Lenny Melfi
442;xyz422@test.com; Tommy Davis
2155;abc2155@google.com; Cindy F

Code:
$ awk -F";" '$1==search{print $2}' search="155" file
xyz155@gmail.com

for variable
Code:
$ acc=155
$ email=$(awk -F";" '$1==search{print $2}' search="$acc" file)
$ echo $email
xyz155@gmail.com

Code:
$ grep "^155" file | cut -d";" -f2
xyz155@gmail.com


Last edited by Akshay Hegde; 01-17-2014 at 12:39 PM.. Reason: typo
This User Gave Thanks to Akshay Hegde For This Post:
# 3  
Old 01-19-2014
Quote:
Any suggestions on how to get only 155?
Code:
grep "^$acc;" "$file"

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

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep for an exact match in a file

I am currently having some issues while trying to grep for a exact string inside a file. I have tried doing this from command line and things work fine i.e. when no match is found, return code=1 but when its done as part of my script it returns 0 for the same command - I dont know if there is an... (6 Replies)
Discussion started by: Ads89
6 Replies

2. Shell Programming and Scripting

Grep exact match without period or other special characters

If I have a file like the following abc.1 abc abc_1 abc..1 abc*1 abc@1 abc def ghr def...... ddef 5466 def ed def** 123445 I`m trying to find exact words from the list abc def (4 Replies)
Discussion started by: ritakadm
4 Replies

3. Shell Programming and Scripting

Grep exact match

Hello! I have 2 files named tacs.tmp and tacDB.txt tacs.tmp looks like this 0 10235647 102700 106800 107200 1105700 tacDB.txt looks like this 100100,Mitsubishi,G410,Handheld,,0,0,0 100200,Siemens,A53,Handheld,,0,0,0 100300,Sony Ericsson,TBD (AAB-1880030-BV),Handheld,,0,0,0... (2 Replies)
Discussion started by: Cludgie
2 Replies

4. Shell Programming and Scripting

Grep or sed - printing line only with exact match

Hello. In my script, some command return : q | kernel-default | package | 3.19.0-1.1.g8a7d5f9 | x86_64 | openSUSE-13.2-Kernel_stable_standard | kernel-default | package | 3.19.0-1.1.g8a7d5f9 | i586 | openSUSE-13.2-Kernel_stable_standard | kernel-default ... (3 Replies)
Discussion started by: jcdole
3 Replies

5. Shell Programming and Scripting

Grep two words with exact match

HI Input : Counters Counter Int Ints Counters Counters Ints Ints I want to grep Counter|Int Output : Counter (1 Reply)
Discussion started by: pareshkp
1 Replies

6. Shell Programming and Scripting

grep and sed exact match questions

This post was previously mistaken for homework, but is actually a small piece of what I working on at work. Please answer if you can. QUESTION1 How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1... (2 Replies)
Discussion started by: thibodc
2 Replies

7. UNIX for Dummies Questions & Answers

grep and sed exact match questions

This was mistaken as homework in a different forum, but is not. These are questions that are close to what I am trying to do at work. QUESTION1: How do you grep only an exact string. I am using Solaris10 and do not have any GNU products installed. Contents of car.txt CAR1_KEY0 CAR1_KEY1... (1 Reply)
Discussion started by: thibodc
1 Replies

8. Solaris

grep exact match

Hi This time I'm trying to grep for an exact match e.g cat.dog.horse.cow.bird.pig horse.dog.pig pig.cat.horse.dog horse dog dog pig.dog pig.dog.bird how do I grep for dog only so that a wc -l would result 2 in above case. Thanks in advance ---------- Post updated at 06:33 AM... (4 Replies)
Discussion started by: rob171171
4 Replies

9. Shell Programming and Scripting

Searching for exact match in a string ??

Hi I have a string of the form XY_X1998.10.500. I want to check in a script that the middle part is always 10. How to achieve this? e.g the input can be XY_X1998.20.500 OR XY_X1998.50.500 OR XY_X1998.10.500. I have to print Yes everytime the middle value is 10 and NO when the middle... (2 Replies)
Discussion started by: skyineyes
2 Replies

10. UNIX for Advanced & Expert Users

Exact Match thru grep ?????

hey..... i do have text where the contents are like as follows, FILE_TYPE_NUM_01=FILE_TYPE=01|FILE_DESC=Periodic|FILE_SCHDL_TYPE=Daily|FILE_SCHDL=|FILE_SCHDL_TIME=9:00am|RESULTS=B FILE_TYPE_NUM_02=FILE_TYPE=02|FILE_DESC=NCTO|FILE_SCHDL_TYPE=Daily|FILE_SCHDL=|FILE_SCHDL_TIME=9:00am|RESULTS=M... (2 Replies)
Discussion started by: manas_ranjan
2 Replies
Login or Register to Ask a Question