AWK to Parse XML messages Post: 302571902

Sponsored Content

Top Forums Shell Programming and Scripting AWK to Parse XML messages Post 302571902 by James_Owen on Tuesday 8th of November 2011 01:43:57 PM

11-08-2011

Registered User

AWK to Parse XML messages

Hello Guys,

Please help with AWK problem. I have XML file which contains a list of messages for subjects.

Example of the messages:

Code:

[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”English” Status=”P”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”Science” Status=”F”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”Science” Status=”F”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”Science” Status=”NA”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”English” Status=”P”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”English” Status=”F”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”Maths” Status=”P”>
[date+time], message=[DATA= “<?xml version=”1.0?”><data changeMsg><Subject=”Science” Status=”P”>

I want to use AWK to parse these xml messages but I am new to awk and to programming.

What I want is to get output of these messages to look like this.

Output

Code:

Subject|Status|Count
  English|P|2
  Science|F|2
  Science|NA|1
  English|F|1
  Maths|P|1
  Science|P|1

Please Help.

Thanks all for any help.

Last edited by radoulov; 11-08-2011 at 03:09 PM.. Reason: Code tags!

James_Owen

View Public Profile for James_Owen

Find all posts by James_Owen

10 More Discussions You Might Find Interesting

1. Programming

parse xml

Hi, I'm looking for an "easy" way to parse a xml file to a proper structure. The xml looks like this What shall I use? Does anybody has some example-code to share or some good links/book-references? thx for any reply -fe

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

3. Shell Programming and Scripting

Need AWk To parse XML logs

Hi , I need an Awk script to parse my log file . 2008-04-26 10:00:13,391 INFO Logger - <?xml version="1.0" encoding="UTF-8" standalone="no"?><2dm tmsg...

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

5. Shell Programming and Scripting

how to parse the file in xml format using awk/nawk

Hi All, I have an xml file with the below format. <a>111</a><b>222</b><c>333<c><d><e>123</e><f>234</f><d><e>456</e><f>789</f> output needed is 111,222,333,123,234 111,222,333,456,789 nawk 'BEGIN{FS="<|>"} {print a,b,c,e,f a="" ...

6. UNIX for Dummies Questions & Answers

Parse XML e report con AWK

Thanks in advance who can answer. I have to make a small shell that after reading an XML file and extract the fields I create a text file with the same fields taken previously in tabular form. I did this parse.awk ---------------------- BEGIN { FS="" } { for(i=2; i<=NF; i+=2) { ...

7. Shell Programming and Scripting

Shell script (not Perl) to parse xml with awk

Hi, I have to make an script according to these: - I have couples of files like: xxxxxxxxxxxxx.csv xxxxxxxxxxxxx_desc.xml - every xml file has diferent fields, but keeps this format: ........ <defaultName>2011-02-25T16:43:43.582Z</defaultName> ...........

8. Shell Programming and Scripting

python - wget xml doc and parse with awk

Well, that's what I'd do in bash :) Here's what I have so far: import urllib2 from BeautifulSoup import BeautifulStoneSoup xml = urllib2.urlopen('http://weatherlink.com/xml.php?user=blah&pass=blah') soup = BeautifulStoneSoup(xml) print soup.prettify() but all it does is grab the html...

9. Shell Programming and Scripting

Please Help with AWK to parse rapidly changing XML messages

Hi Guy's Can I please get some help with this code. I have xml feed file which rapidly changing temporary file and I need to capture the content of this file as soon as data arrives. Example of the data Required data output Time is current time. This is awk code that I have so far...

10. Shell Programming and Scripting

awk Script to parse a XML tag

I have an XML tag like this: <property name="agent" value="/var/tmp/root/eclipse" /> Is there way using awk that i can get the value from the above tag. So the output should be: /var/tmp/root/eclipse Help will be appreciated. Regards, Adi

LEARN ABOUT DEBIAN

actdiag

ACTDIAG(1)						      General Commands Manual							ACTDIAG(1)

NAME

       actdiag - generate activity-diagram image file from spec-text file.

SYNOPSIS

       actdiag [options] files

DESCRIPTION

       This manual page documents briefly the actdiag commands.

       actdiag is a program that generate activity-diagram image file from spec-text file.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.	For a complete description, see the Info files.

       -h, --help
	      show this help message and exit

       -a, --antialias
	      Pass diagram image to anti-alias filter

       -c FILE, --config=FILE
	      read configurations from FILE

       -o FILE
	      write diagram to FILE

       -f FONT, --font=FONT
	      use FONT to draw diagram

       -s, ----separate
	      Separate diagram images for each group (SVG only)

       -T TYPE
	      Output diagram as TYPE format

SEE ALSO

       The programs are documented fully by
       http://tk0miya.bitbucket.org/actdiag/build/html/index.html

AUTHOR

       actdiag was written by Takeshi Komiya <i.tkomiya@gmail.com>

       This manual page was written by Kouhei Maeda <mkouhei@palmtb.net>, for the Debian project (and may be used by others).

								   June  5, 2011							ACTDIAG(1)

10 More Discussions You Might Find Interesting

1. Programming

parse xml

Discussion started by: bin-doph

2. Shell Programming and Scripting

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

Discussion started by: girigopal

3. Shell Programming and Scripting

Need AWk To parse XML logs

Discussion started by: amit1_x

4. Shell Programming and Scripting

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

Discussion started by: MissI