Visit Our UNIX and Linux User Community


How to parse the following xml file

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support How to parse the following xml file
# 1  
Old 07-30-2009
How to parse the following xml file

Hi,

I have the following file

Example.xml

<?xml version="1.0" encoding="iso-8859-1"?>

<html><set label="09/07/29" value="1241.90"/>

</html>

Can any one help me in parsing this xml file

I want to retrive the attribute values of the tag set

Example I want to store 09/07/29 to variable1 and 1241.90 to variable2 in order to insert this data into a database table.


Appreciate if any one can help me..very urgent
# 2  
Old 07-30-2009
this might not be the best way, but you could try:
Code:
variable1=`perl -nl -e 'if (m/label=\"(.*?)\"/) { print $1;} ' newfile.txt`
variable2=`perl -nl -e 'if (m/value=\"(.*?)\"/) { print $1;} ' newfile.txt`

# 3  
Old 07-30-2009
I think it is a good way Smilie

@Raji_gadam
Please use CODE-tags next time you post code, data or logs to enhance readability and to preserve formatting like indention etc., ty.

Just for variety with sed:
Code:
LABEL=`sed -n 's/.*label="\([^\"]*\)".*/\1/p' infile`
VALUE=`sed -n 's/.*value="\([^\"]*\)".*/\1/p' infile`

# 4  
Old 09-23-2009
try using xmllint and xpath ... you can extract exactly what you want..
example: the file is called t.xml

Code:
echo 'cat /html/set/@label' | xmllint --shell t.xml | grep '='

will get you label

Code:
echo 'cat /html/set/@value' | xmllint --shell t.xml | grep '='

will get you set ...
Now pipe to awk or sed and extract what you want ...
This will work with any size XML ..

Last edited by Neo; 09-23-2009 at 08:32 AM.. Reason: added code tags - please use them, thanks!
This User Gave Thanks to chakrapani For This Post:

Previous Thread | Next Thread
Test Your Knowledge in Computers #723
Difficulty: Medium
Niklaus Emil Wirth, an Austrian computer scientist, designed several programming languages, including Pascal,
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse xml file

I am trying to create a shell script that will parse an xml file (file attached). awk '/Id v=/ { print }' Test.xml | sed 's!<Id v=\"\(.*\)\"/>!\1!' > output.txt An output.txt file is created but it is empty. It should contain the value 222159 in it. Thanks. (7 Replies)
Discussion started by: cmccabe
7 Replies

2. Shell Programming and Scripting

Parse XML File.

HI Guys I have Below XML File : <xn:SubNetwork id="XYZ"> <xn:SubNetwork id="C01"> <xn:MeContext id="CO1"> <xn:ManagedElement id="1"> <un:RncFunction id="1"> <un:UtranCell id="NY431"> ... (2 Replies)
Discussion started by: pareshkp
2 Replies

3. UNIX for Dummies Questions & Answers

Parse xml file

HI Guys, Input .XML <xn:MeContext id="L0307"> <xn:ManagedElement id="1"> <xn:VsDataContainer id="1"> <xn:attributes> <xn:vsDataType>vsDataENodeBFunction</xn:vsDataType> ... (3 Replies)
Discussion started by: pareshkp
3 Replies

4. Programming

Parse XML file

How do I get the field info for tags ID, NAME, DESCRIPTION. Below is my current code put I can't get beyond the first_child of the file. use strict; use warnings; use XML::Simplehttp://images.intellitxt.com/ast/adTypes/icon1.png; use... (1 Reply)
Discussion started by: leemalloy
1 Replies

5. Shell Programming and Scripting

parse xml file

Hello all, Given the following extract from a xml file with multiple <JOB> .... </JOB> entries <JOB APPLICATION="APP" APR="0" AUG="0" AUTHOR="AUT" AUTOARCH="0" CMDLINE="/tmp/test1 %%var" CONFIRM="1" CREATION_DATE="20100430" CREATION_TIME="130739" ... (2 Replies)
Discussion started by: cabrao
2 Replies

6. Shell Programming and Scripting

Parse an XML task list to create each task.xml file

I have an task definition listing xml file that contains a list of tasks such as <TASKLIST <TASK definition="Completion date" id="Taskname1" Some other <CODE name="Code12" <Parameter pname="Dog" input="5.6" units="feet" etc /Parameter> <Parameter... (3 Replies)
Discussion started by: MissI
3 Replies

7. Shell Programming and Scripting

How can I parse xml file?

How can I parse file containing xml ? I am sure that its best to use perl - but my perl is not very good - can someone help? Example below contents of file containing the xml - I basically want to parse the file and have each field contained in a variable.. ie. I want to store the account... (14 Replies)
Discussion started by: frustrated1
14 Replies

8. Shell Programming and Scripting

Parse String in XML file

Hello All, I am new to this and I need to parse an XML file. Here's the XML Input File: <Report version="1.2"> <summary fatals="0" testcases="1" expected_fails="0" unexpected_passes="0" warnings="9" tests="21" errors="0" fails="1" passes="20" /> <testresult... (4 Replies)
Discussion started by: racbern
4 Replies

9. Shell Programming and Scripting

Parse XML file

Hi, I need to parse the following XML data enclosed in <a> </a> XML tag using shell script. <X> ..... </X> <a> <b> <c>data1</c> <c>data2</c> </b> <d> <c>data3</c> </d> </a> <XX> ... </XX> (5 Replies)
Discussion started by: viki
5 Replies

10. Shell Programming and Scripting

How to parse a XML file using PERL and XML::DOm

I need to know the way. I have got parsing down some nodes. But I was unable to get the child node perfectly. If you have code please send it. It will be very useful for me. (0 Replies)
Discussion started by: girigopal
0 Replies

Featured Tech Videos