Problems Grepping within multiple Quotes


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Problems Grepping within multiple Quotes
# 1  
Old 01-19-2011
Problems Grepping within multiple Quotes

Hello, I have a block of code (XML) that I would like to grep for certain information. The basic format of the XML is the following repeated a few hundred times, each time with a unique ID:

<Identifier ID="A" NAME="John Doe" AGE="32 Years" FAMILY="4" SEX="MALE"></Identfier>

I would like to create a statement that grabs the ID, Name, and Age of the individual.

What I've done so far is grep the XML file with the following:
grep "ID=" file1.xml

but when I do so, I get the entire line. Is there a command I can use that would give me an output similar to the following?:
HTML Code:
A    John Doe    32 Years
# 2  
Old 01-19-2011
Code:
sed 's/.*ID=\"\(.*\)\" NAME=\"\(.*\)\" AGE=\"\(.*\)\" FAMILY.*/\1 \2 \3/' infile

# 3  
Old 01-19-2011
Quote:
Originally Posted by rdcwayx
Code:
sed 's/.*ID=\"\(.*\)\" NAME=\"\(.*\)\" AGE=\"\(.*\)\" FAMILY.*/\1 \2 \3/' infile

rdcwayx, thanks for the help. I tried running your command, but the whole entire block was returned and not the text found within the quotes.
# 4  
Old 01-19-2011
there are some hide characters in your files.

upload some samples here
# 5  
Old 01-19-2011
Sorry for not being through. Here is a sample block:

<Identifier ID="A" Guid="{8a79eb5-88f8-4a7b-4a1b-67ff369be696}" NAME="JOHN DOE" QUALIFIER="YES" DT="3010" LIMITATOR="" Description="" Deadband="" Key="2887" STATUS="0" DOAP="0" AGE="32 YEARS" SEX="MALE">
</Identifier>
# 6  
Old 01-19-2011
Code:
sed 's/.*ID="\([^"]*\)".*NAME="\([^"]*\)".*AGE="\([^"]*\)".*/\1 \2 \3/' infile |grep -v "<\/Identifier>"

This User Gave Thanks to rdcwayx For This Post:
# 7  
Old 01-20-2011
rdcwayx,
thanks for all your help. Your command worked like a charm!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grepping or awking multiple lines in a file - regex

data.txt: hellohellohello mellomello1mello tellotellotellotello bellobellowbellow vellow My attempts: egrep ".*mello1\n.*bellow" data.txt awk '/.*mello1.*\nbellow/' data.txt how can i search for patterns that are on different lines using simple egrep or awk? i only want the... (7 Replies)
Discussion started by: SkySmart
7 Replies

2. Shell Programming and Scripting

Grepping multiple strings from one column

I have 3-column tab separated data that looks like the following: act of+n-a-large+vn-tell-v 0.067427 act_com of+n+n-a-large-manufacturer-n 0.129922 act-act_com-com in+n-j+vn-pass-aux-restate-v 0.364499666667 com nmod+n-j+ns-invader-n 0.527521 act_com-com obj+n-a-j+vd-contribute-v 0.091413... (2 Replies)
Discussion started by: owwow14
2 Replies

3. Shell Programming and Scripting

Grepping multiple lines in a file

HI I have a file with output as System: cu=4 ent=0.1 mode=on cu min u s w i 0 500 0.1 0.3 0.5 0.1 1 200 0.5 0.2 0.3 0.0 I need to grep the values of following column fields u, s, w and i from each row sum them up and store in a variable..:( Please help.. (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

4. Programming

Grepping a column from multiple file

I have 20 files that look pretty much like this: 0.01 1 3822 4.97379915032e-14 4.96982253992e-09 0 0.01 3822 1 4.97379915032e-14 4.96982253992e-09 0 0.01 2 502 0.00993165137406 993.165137406 0 0.01 502 2 0.00993165137406 993.165137406 0 0.01 4 33 0.00189645523539 189.645523539 0 0.01 33 4... (5 Replies)
Discussion started by: kayak
5 Replies

5. Shell Programming and Scripting

grepping multiple matches in a single string

Hi All, I'm trying to grep for 3 patterns in a string of gibberish. It so happens that each line is appended by a date/time stamp and i was able to figure out how to extract only the datetime. here is the string.. i have to display tinker tailor soldier spy Please can some help... (2 Replies)
Discussion started by: Irishboy24
2 Replies

6. Shell Programming and Scripting

Grepping multiple terms with different arguments

Grep -e 'term1' -A1 -e 'term2' -A3The above code always searches for either term and prints results + next three lines. I'm trying to print out: foo foo foo term1 bar bar bar line right after the above -- la la la la term2 so so so line right after the above and again and again I've... (7 Replies)
Discussion started by: dkozel
7 Replies

7. Shell Programming and Scripting

Grepping Multiple Strings on the Same Line 'Or'

I've got this command that I've been using to find strings on the same line, say I'm doing a search for name: find . -name "*" | xargs grep -i "Doe" | grep -i "John" > output.txt This gives me every line in a file that has John and Doe in it. I'm looking to add a OR operator for the second... (5 Replies)
Discussion started by: Rally_Point
5 Replies

8. Shell Programming and Scripting

Grepping using multiple wildcards

Is there anyway you can grep using multiple wildcards? When I run the below line the results return fine; grep 12345 /usr/local/production/soccermatchplus/distributor/clients/*/out/fixtures.xml | awk -F/ '{print $8}' However ideally, I need it to grep for; grep 12345... (3 Replies)
Discussion started by: JayC89
3 Replies

9. Shell Programming and Scripting

problems with double quotes in PERL

I have a cgi script I run through apache2 and I need to have a line that contains double quotes within double quotes. Here's what I need PERL to pass to rrdtool: HRULE:30#BBBB00:"30.0 constant":dashesIt's a little more complicated since I also have variables in the statement which requires... (13 Replies)
Discussion started by: audiophile
13 Replies

10. Shell Programming and Scripting

Trouble grepping for multiple strings

I am having a heck of a time trying to write a script that will grep for multiple strings in a single file. I am really at my wits end here and I am hoping to get some feedback here. Basic information: OS: Solaris 9 Shell: KSH Oracle Database server I was trying to grep through a file... (5 Replies)
Discussion started by: thecoffeeguy
5 Replies
Login or Register to Ask a Question