How to get the exact word in awk?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to get the exact word in awk?
# 1  
Old 07-01-2013
How to get the exact word in awk?

Hi,

i have a file that contains the following:
Code:
ARTPRD01_app =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 11.222.3.4)(PORT = 1540))
    (CONNECT_DATA =
      (SERVICE_NAME = artprd01.com)
ARTPRD01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 11.223.3.1)(PORT = 1540))
    (CONNECT_DATA =
      (SERVICE_NAME = artprd01..com

when i type in the awk command

Code:
awk '/^ARTPRD01/,/SERVICE_NAME/' tnsnames.dat

This gives me an output same as mentioned above. my desired output should only be:

Code:
ARTPRD01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 11.223.3.1)(PORT = 1540))
    (CONNECT_DATA =
      (SERVICE_NAME = artprd01..com

Moderator's Comments:
Mod Comment IP addresses have been mangled to protect the innocent...

Last edited by Don Cragun; 08-05-2014 at 12:14 AM.. Reason: hide private data
# 2  
Old 07-01-2013
Code:
awk '/^ARTPRD01 =/,/SERVICE_NAME/' tnsnames.dat

These 2 Users Gave Thanks to Yoda For This Post:
# 3  
Old 07-01-2013
many thanks YODASmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep exact math word

Hi All, i want exact math to search to find it and i tried as like below it not working. My Excepted out : should not get the output that mean exact word math. echo "test.txt|123"|sed 's/|/ /g'|grep -w "test" Thanks (1 Reply)
Discussion started by: bmk123
1 Replies

2. UNIX for Beginners Questions & Answers

Grep multiple exact word

Hi I am trying to grep multiple exact word from log file and directing it to a new file. however my log file has many numeric values, such as 0400, 0401, 0404 and all html error also starts with 404, 401 etc so I just want to grep only when 404, 401 etc is coming, NOT 0400, OR 0401 i have... (8 Replies)
Discussion started by: scazed
8 Replies

3. Shell Programming and Scripting

How to take exact word from output.?

Hi i am writing and i want to take very first word "A924A5FC"from the below o/p A924A5FC 0910055313 P S SYSPROC SOFTWARE PROGRAM ABNORMALLY TERMINATED A924A5FC 0908091913 P S SYSPROC SOFTWARE PROGRAM ABNORMALLY TERMINATED A924A5FC 0906090313 P S SYSPROC SOFTWARE... (4 Replies)
Discussion started by: scriptor
4 Replies

4. Shell Programming and Scripting

Grep Exact word

This may be stupid question but not able to solve it. How to grep exact word and line along with it. TEST:/u00/app/oracle/product/10.2.0/TEST:N TEST2:/u00/app/oracle/product/10.2.0/ODS:N TEST3:/u00/app/oracle/product/10.2.0/TEST:N TEST4:/u00/app/oracle/product/10.2.0/ODS:N... (4 Replies)
Discussion started by: tapia
4 Replies

5. UNIX for Dummies Questions & Answers

Find EXACT word in files, just the word: no prefix, no suffix, no 'similar', just the word

I have a file that has the words I want to find in other files (but lets say I just want to find my words in a single file). Those words are IDs, so if my word is ZZZ4, outputs like aaZZZ4, ZZZ4bb, aaZZZ4bb, ZZ4, ZZZ, ZyZ4, ZZZ4.8 (or anything like that) WON'T BE USEFUL. I need the whole word... (6 Replies)
Discussion started by: chicchan
6 Replies

6. Shell Programming and Scripting

to get the exact word from the file using script

Hi everybody, I have one requirment, i have to get the particular server name from a file. EX: File contents will be like below.. $cat test.txt HostAssignments->new("server1", [ "PS_SERVER", "REG_SERVER", "PS_ORACLE", "OM_G10_AUD", "OM_G10_CAD", "OM_G10_CHF", ... (3 Replies)
Discussion started by: raghu.iv85
3 Replies

7. Shell Programming and Scripting

Replace exact word with blank

i have a file with the below content file1.txt ALERTADMIN.FIELD ALERTADMIN.TX_ALERTS_LOG i have another file file2 ALERTADMIN.FIELD ALERTADMIN.FIELD_WS ALERTADMIN.SECTION_FIELD_WS ALERTADMIN.TX_ACCT_PROCESSING_WORK_TABLE ALERTADMIN.TX_ACCT_REVIEW_EXEC_METRICS... (2 Replies)
Discussion started by: lavnayas
2 Replies

8. Shell Programming and Scripting

Exact Word Match

I'm trying to find a exact word match but couldn't do it. ABC ABC_NE Searching for ABC_NE tried grep -w </ABC_NE/> grep "^ABC_NE$" but didn't worked , any awk variants would also help. ---------- Post updated at 08:40 AM ---------- Previous update was at 06:48 AM ---------- I... (2 Replies)
Discussion started by: dinjo_jo
2 Replies

9. Shell Programming and Scripting

AWK seach for exact word in certain column

Can anyone help me how I will extract all lines in a file where the word "worker" or "co-worker" in 2nd column exist. There are also word in 2nd column like "workers" or "worker2" but I don't want to display those lines. Appreciate any help in advance! Thank you! (5 Replies)
Discussion started by: Orbix
5 Replies

10. UNIX for Dummies Questions & Answers

exact string match in a word

Hi all, Is anyone able to help with the following query? I have an input file with several lines of words, e.g. "hellolaylahello" "hellohellohellolayla" I want to search for the exact string "hello" in each line and display: 2 "hellolaylahello" 3 "hellohellohellolayla" I... (11 Replies)
Discussion started by: dr_sabz
11 Replies
Login or Register to Ask a Question