Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Capture the value between brackets

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Capture the value between brackets
# 1  
Old 09-04-2014
Capture the value between brackets
Hi
I am having hard time getting this right and need some help. I Have 3 files, and everyone contains the following:-

File1
Code:
Today, we have  Name(Jack)     Age(19)    Class (A2)
 Today, we have Name(Kim) Class (G9)

File2
Code:
Today, we have  Name(Lee)     Age(19)    Class (A2)
Today, we have Name(Nile)     Age (45)   Class (4R)
Today, we have Name(Kim) Class (G9)   Class (4R)

File3
Code:
Today, In Class (4T) we have  Name(Nick)     Age(19)   
Today, In Class (4Y) we have  Name(Sara)     Age(14) 
Today, In Class (4Y) we have  Name(Nile)     Age (45) 
Today, In Class (4Y) we have  Name(Jack)     Age(19)

I need to capture the value between brackets after Name only, but I don't want the name to be print twice.

So ,I am looking for output like this :-

Code:
Jack
Kim
Lee
Nile
Nick
Sara

Thank you
Last edited by Scrutinizer; 09-04-2014 at 03:23 AM.. Reason: code tags
# 2  
Old 09-04-2014
Code:
awk -F '[) (]' '{for(i=1; i<=NF; i++) {if($i == "Name") a[$(i+1)]}} END {for(x in a) print x}' File*

# 3  
Old 09-04-2014
Samsan,

Please use the code tags as per forum rules for any commands/codes etc.
Also is this a home work? If yes then you should follow the forum rules and post this in correct forum, please confirm the same. If this is not then kindly let us know if you have tried some thing here to solve this problem.


Thanks,
R. Singh
# 4  
Old 09-04-2014
Thank you SriniShoo, but it did not work, I am getting this error

awk: syntax error near line 1
awk: bailing out near line 1

by the way , I am using SunOS
# 5  
Old 09-04-2014
Please answer @RavinderSingh13 questions
# 6  
Old 09-04-2014
Sorry Ravinder , I am new here , next time I follow the rule. No it is not homework. It is part of script I am wrting for WebSphere WAS for my work. I am using the above as sample example
# 7  
Old 09-04-2014
Another one:
Code:
awk -F '.*Name[(]|[)]' '!A[$2]++{print $2}' file*

On Solaris use /usr/xpg4/bin/awk rather than awk


---
@Srinishoo there should be no space in the the Field Separator otherwise it will not find names with spaces in them...
Code:
awk -F '[)(]' '{for(i=1; i<=NF; i++) {if($i~/Name$/) ....

Last edited by Scrutinizer; 09-04-2014 at 03:35 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Brackets

Hi all. i need a small help. i have written an exit code, which will check whether mo.sh is successful or not. if the status is >0 it will exit the shell. 1>Do you guys think it is a correct way to write? 2>what if i change the double bracket to single. how will it change the o/p. ... (1 Reply)
Discussion started by: sub
1 Replies

2. Shell Programming and Scripting

adding brackets

Hi, If you suppose that you have two columns of numbers, and I want to merge these two columns into one and put a bracket around it. and perphaps add a dash between two numbers. input.txt 1 2 3 4 5 6 7 8 output.txt (1-2) (3-4) (5-6) (7-8) Thanks in advance! Please use... (2 Replies)
Discussion started by: johnkim0806
2 Replies

3. Shell Programming and Scripting

Delete text between square brackets and also delete those square brackets using sed or awk

Hi All, I have a text file which looks like this: computer programming systems engineering I want to get rid of these square brackets and also the text that is inside these brackets. So that my final text file looks like this: computer programming systems engineering I am using... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies

4. Shell Programming and Scripting

How to get the value in the first brackets

Hello, I am trying to write a script using ksh. And I want to get the value within the first brackets of a string. For example: 14/04/11 11:35: 00 This is (nn) from the earth. Then i hope to get nn in this case. Can any one advise me how to implement it? Thank you very much! nn (2 Replies)
Discussion started by: n_n
2 Replies

5. Shell Programming and Scripting

Get value between brackets

Hi I am having hard time getting this right and need some help. I Have several log files, and everyone contains the following 3 lines at the end: 4 ETW000 Disconnected from database. 4 ETW000 End of Transport (0000). 4 ETW000 date&time: 13.01.2011 - 08:03:28 I need to capture the value... (7 Replies)
Discussion started by: nimo
7 Replies

6. Shell Programming and Scripting

help to delete brackets [ ]

hi all, i want to delete brackets in all the file and to keep the string or data between them ( example Q --> Qxxx) with sed command.. thanks (4 Replies)
Discussion started by: kamel.seg
4 Replies

7. UNIX for Dummies Questions & Answers

usage of brackets for if

Hi, I would like to know about the usage of brackets to negate a set of boolean evaluations an equivalent to what i am trying is below if or || ] ] then echo"valid time of day" else echo "invalid input" exit fi the bracket structue as mentioned doesnt work .. i am using ksh.... (4 Replies)
Discussion started by: lakshmikanth
4 Replies

8. Shell Programming and Scripting

how do you use brackets ?? in a script.

:D i am pretty much new to scripting and don't want to pick up bad habits so I am trying to get myself to use brackets in my scripts since I plan on using them alot.. ! in this example of a script I wrote I can not figure out where the brackets go can anyone give me some insight into the use of... (3 Replies)
Discussion started by: moxxx68
3 Replies

9. UNIX for Dummies Questions & Answers

square brackets

I would like to substitute a phrase which contains square brackets. change TO how? Thanks (2 Replies)
Discussion started by: gilead29
2 Replies

10. Post Here to Contact Site Administrators and Moderators

Angle brackets

From the Apache thread in the Adanced forum: Thats because your browser interprets anything within angle brackets to be an HTML tag. You need to quote these brackets if you want them to appear correctly. The proper quotes are: &amp;lt; for < and &amp;gt; for > So, for example, you would have... (1 Reply)
Discussion started by: PxT
1 Replies
Login or Register to Ask a Question