XML Parsing Post: 302601592

Sponsored Content

Top Forums UNIX for Advanced & Expert Users XML Parsing Post 302601592 by manas_ranjan on Friday 24th of February 2012 03:56:19 AM

02-24-2012

Registered User

XML Parsing

I had a big XML and from which I have to make a layout as below

Code:

*TOTAL+CB      |		*CB+FX		|  CS		|*IR	      |	*TOTAL	         |
--------------------------------------------------------------------------------------------------
	       |CB		FX		|		|	      |			 |
DMFXNY	EMSGFX |DMFXNY	EMSGFX	DMFXNY	EMSGFX	|DMFXNY	EMSGFX	|DMFXNY	EMSGFX|	DMFXNY	EMSGFX	 |

so I fitered out from that big XML with required fields to make out this layout, but not able to proceed further to make layout like this .
So after filter from the big XML, the new xml having data looks like below,

Code:

<item>TOTAL+CB</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>TOTAL+CB</item>
              <item>AllMember</item>
              <item>EMSGFX</item>
              <item>CB+FX</item>
              <item>CB</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>CB+FX</item>
              <item>CB</item>
              <item>AllMember</item>
              <item>EMSGFX</item>
              <item>CB+FX</item>
              <item>FX</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>CB+FX</item>
              <item>FX</item>
              <item>AllMember</item>
              <item>EMSGFX</item>
              <item>CS</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>CS</item>
              <item>AllMember</item>
              <item>EMSGFX</item>
              <item>IR</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>IR</item>
              <item>AllMember</item>
              <item>EMSGFX</item>
              <item>TOTAL</item>
              <item>AllMember</item>
              <item>DMFXNY</item>
              <item>TOTAL</item>
              <item>AllMember</item>
              <item>EMSGFX</item>

can anyone suggest how can I make this one. Please suggets in shell scripts .

Last edited by manas_ranjan; 02-24-2012 at 05:35 AM..

manas_ranjan

View Public Profile for manas_ranjan

Find all posts by manas_ranjan

10 More Discussions You Might Find Interesting

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

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

3. Shell Programming and Scripting

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

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

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

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

8. 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=""...

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

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

LEARN ABOUT REDHAT

xml::dumper

Dumper(3)						User Contributed Perl Documentation						 Dumper(3)

NAME

       XML::Dumper - Perl module for dumping Perl objects from/to XML

SYNOPSIS

	# Convert Perl code to XML
	use XML::Dumper;
	my $dump = new XML::Dumper;
	$data = [
		 {
		   first => 'Jonathan',
		   last => 'Eisenzopf',
		   email => 'eisen@pobox.com'
		 },
		 {
		   first => 'Larry',
		   last => 'Wall',
		   email => 'larry@wall.org'
		 }
		];
	$xml =	$dump->pl2xml($perl);

	# Convert XML to Perl code
	use XML::Dumper;
	my $dump = new XML::Dumper;

	# some XML
	my $xml = <<XML;
       <perldata>
	<scalar>foo</scalar>
       </perldata>
       XML

	# load Perl data structure from dumped XML
	$data = $dump->xml2pl($Tree);

DESCRIPTION

       XML::Dumper dumps Perl data to a structured XML format.	XML::Dumper can also read XML data that was previously dumped by the module and
       convert it back to Perl.

       This is done via the following 2 methods: XML::Dumper::pl2xml XML::Dumper::xml2pl

AUTHOR

       Jonathan Eisenzopf <eisen@pobox.com>

CREDITS

       Chris Thorman <ct@ignitiondesign.com> L.M.Orchard <deus_x@pobox.com> DeWitt Clinton <dewitt@eziba.com>

SEE ALSO

       perl(1), XML::Parser(3).

perl v5.8.0							    1999-06-20								 Dumper(3)

10 More Discussions You Might Find Interesting

1. Programming

XML parsing

Discussion started by: handak9

2. Shell Programming and Scripting

parsing xml

Discussion started by: walnut

3. Shell Programming and Scripting

XML Parsing

Discussion started by: Mavericc

4. Shell Programming and Scripting

XML parsing

Discussion started by: LavanyaP

5. Shell Programming and Scripting

Parsing XML

Discussion started by: ManoharMa

6. Shell Programming and Scripting

Parsing XML

Discussion started by: $criptKid617

7. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

Discussion started by: ripat

8. Shell Programming and Scripting

XML parsing

Discussion started by: vivek d r

9. Shell Programming and Scripting

XML Parsing :

Discussion started by: asavaliya

10. Shell Programming and Scripting

XML parsing

Discussion started by: r_t_1601

LEARN ABOUT REDHAT

xml::dumper