XML Parsing


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting XML Parsing
# 1  
Old 09-16-2008
MySQL XML Parsing

Hi,

Need a script to parse the following xml file content

<tag1 Name="val1">
<abc Name="key"/>
<abc Name="pass">*********</abc>
</tag1>
<tag2 Name="Core">
<Host Name="a.b.c">
<tag1 Name="abc">
<abc Name="ac">None</abc>
<abc Name="as">None</abc>
<tag1 Name="pkg">
<tag1 Name="one">
<tag1 Name="two">
<abc Name="Version">1.3</abc >
<abc Name="Status">installed</abc >
<abc Name="InstalledName">two</abc >
</tag1 >
</tag1 >
</tag1 >
<abc Name="SystemType">SunOS</abc >
</tag1 >
</Host>
</tag2>


I can have multiple entries of Host tag so i need to search for a host with a given value and then get the attribute "ac" for a tag "abc" for the given Host

Thanks in advance.

Mavericc
# 2  
Old 09-16-2008
Try this:

Code:
awk -F '[<>]+' '
        /Host Name="a.b.c"/ { found=1 }
        found && /Name="ac"/ { print $3; found=0 }
' inputfile

# 3  
Old 09-16-2008
Works..but need more

Thanks...

It works if the "a.b.c" is hardcoded. How to go about if I were to pass it as argument.

Tried storing it in a variable and passed. But fails

Mavericc.
# 4  
Old 09-16-2008
MySQL Doesn't work on Solaris

Unfortunately this script does not work on Solaris.
The "&&" seems to be the culprit, as removing this stops throwing compilation error

Any help would be of much help.

Mavericc
# 5  
Old 09-16-2008
Use /usr/xpg4/bin/awk on Solaris.

Regards
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

XML parsing

I have an xml file where the format looks like below <SESSIONCOMPONENT REFOBJECTNAME ="pre_session_command" REUSABLE ="NO" TYPE ="Pre-session command"> <TASK DESCRIPTION ="" NAME ="pre_session_command" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1"> ... (8 Replies)
Discussion started by: r_t_1601
8 Replies

2. Shell Programming and Scripting

XML Parsing :

HI I want to parse below file in to two output :- Input :- ?xml version="1.0" encoding="UTF-8"?> <bulkCmConfigDataFile xmlns:un="utranNrm.xsd" <configData dnPrefix="Undefined"> <xn:SubNetwork id="ONRM_ROOT_MO_R"> <xn:MeContext id="C136"> ... (3 Replies)
Discussion started by: asavaliya
3 Replies

3. Shell Programming and Scripting

XML parsing

i have xml output in below format... <AlertsResponse> <Alert id="11216" name="fgdfg"> <AlertActionLog timestamp="1356521629778" user="admin" detail="Recovery Alert"/> </Alert> <Alert id="11215" name="gdfg <AlertActionLog timestamp="1356430119840" user=""... (12 Replies)
Discussion started by: vivek d r
12 Replies

4. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere. I can not supply any sample file as it contains private data but you can download your own contacts using this script: #!/bin/sh # imports... (9 Replies)
Discussion started by: ripat
9 Replies

5. Shell Programming and Scripting

Parsing XML

I am trying to parse an xml file and trying to grab certain values and inserting them into database table. I have the following xml that I am parsing: <dd:service name="locator" link="false"> <dd:activation mode="manual" /> <dd:run mode="direct_persistent" proxified="false" managed="true"... (7 Replies)
Discussion started by: $criptKid617
7 Replies

6. UNIX for Advanced & Expert Users

XML Parsing

I had a big XML and from which I have to make a layout as below *TOTAL+CB | *CB+FX | CS |*IR | *TOTAL | -------------------------------------------------------------------------------------------------- |CB FX | | | | DMFXNY EMSGFX... (6 Replies)
Discussion started by: manas_ranjan
6 Replies

7. Shell Programming and Scripting

Parsing XML

Learned People, Hello ! Till today, for the most part, all of the tricky questions/situations that I encountered were already posted by other folks and all I had to do was peruse through these one at a time and I could find some sort of an answer and all I had to do was add some minor tweaks... (5 Replies)
Discussion started by: ManoharMa
5 Replies

8. Shell Programming and Scripting

XML parsing

I have a xml file attached. I need to parse parameterId and its value My output should be like 151515 38 151522 32769 and so on.. Please help me. Its urgent (6 Replies)
Discussion started by: LavanyaP
6 Replies

9. Shell Programming and Scripting

parsing xml

I want to use wget comment to parse an xml parse that exist in an online website. How can I connect it using shell script through Unix and how can I parse it?? (1 Reply)
Discussion started by: walnut
1 Replies

10. Programming

XML parsing

Hi I want to take an XML file and transform it into a pipe-delimited format. What is the best tool to use for this? I have libxml2 which seems to be the best xml parser around. The xml file will have the following format. <Txn> <Date>120504</Date> <id>99</id> <Items> <Item>... (1 Reply)
Discussion started by: handak9
1 Replies
Login or Register to Ask a Question