Parse String in XML file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parse String in XML file
# 1  
Old 12-14-2007
Bug 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 line="../shared/scripts/addElement.js:573" message="Add Network Element [ Tampines ] successfully created" result="PASS" time="2007-12-13T16:23:47" />
</Report version>

The expected output should be:
Report

summary fatals=0 testcases=1 expected_fails=0 unexpected_passes=0 warnings=9 tests=21 errors=0 fails=1 passes=20

Add Network Element [ Tampines ] successfully created -- PASS


Can you help me with the script to have the output?


Thanks in advance.
racbern
# 2  
Old 12-14-2007
take a look at this little script I wrote to parse your basic sqlplus login string

input should be in the format user/pass@inst
Code:
#!/usr/bin/ksh

######################
## login string parser
######################

echo "Input your login string:"
read string

echo "\nYou entered: $string"
export SRC_USERPASS=${string%%@*}
export SRC_USER=${SRC_USERPASS%%/*}
export SRC_INST=${string##*@}

## echo "USER and PASS: $SRC_USERPASS"
echo $SRC_USERPASS | grep /
if [ $? = 0 ]
then
	echo "There is a password"
	export SRC_PASS=${SRC_USERPASS##*/}
	echo "USER only: $SRC_USER"
	echo "PASS only: $SRC_PASS"
	echo "INST: $SRC_INST"
else
	echo "There is NO password"
	echo "You will be prompted for a password during execution"
	echo "USER only: $SRC_USER"
	echo "PASS only: $SRC_PASS"
	echo "INST: $SRC_INST"
fi

hopefully this gets you started, but your parsing will be a bit more complex.

I suggest doing it line by line, then argument by argument.
something like supply the script your xml file, then grep it for the entire summary line. then parse that string for each variable (fatals, testcases, ...) (you will lbe ooking for whatever comes after fatals=" and then before the next ")
then grep the testresults line for the message and result variable.

Let us know how far you get.
Zelp
# 3  
Old 12-16-2007
Parse String in XML file

Hello,

Has anyone got an idea how can I parse the above XML file by using shell script or perl?

Thanks in advance to all who will reply.

Thanks,
racbern
# 4  
Old 12-16-2007
sed

hi

Please try this one:
Code:
cat filename | sed  's/<Report.*$/report/' | sed 's/<summary//' | sed 's/\/>//' | sed 's/"//g' | sed 's/<testresult.*message=//'| sed 's/result=.*$//' | sed 's/<\/Report version>//'

# 5  
Old 12-19-2007
Hi Summer Cherry,

I tried your suggestion and it worked..
Thanks a lot for your help.

Regards,
racbern
Login or Register to Ask a Question

Previous Thread | Next Thread

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. 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

4. Shell Programming and Scripting

How to parse xml file in variable-string?

In the wake of the post: how-parse-following-xml-file Thank you for the very useful chakrapani response 302355585-post4 ! A close question. How to pass a file to xmllint in variable? For example, let it be: NEARLY_FILE='<?xml version="1.0" encoding="iso-8859-1"?><html><set label="09/07/29"... (0 Replies)
Discussion started by: OleM2k
0 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. Emergency UNIX and Linux Support

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... (3 Replies)
Discussion started by: Raji_gadam
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 a string in XML file using shell script

Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it... (46 Replies)
Discussion started by: ayhanne
46 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
Login or Register to Ask a Question