XML Manipulating

anandhkumar · January 12, 2010, 12:44pm

Hi everybody

    Can anybody there help me in solving the following issue.

Consider the XML

  <row>
     <column>Business Strategy</column>
     <column>bus1</column>
  </row>
  <row>
     <column>Company Description</column>
     <column>tar1</column>
  </row>
  <row>
      <column>Business Strategy</column>
      <column>bus2</column>
  </row>
  <row>
      <column>Company Description</column>
      <column>tar2</column>
  </row>
  <row>
     <column>Business Strategy</column>
     <column>bus3</column>
  </row>
  <row>
     <column>Company Description</column>
     <column>tar3</column>
  </row>

Can this xml be parsed and manipulated in ruby as

  <row>
     <column>Business Strategy</column>
     <column>bus1</column>
     <column>bus2</column>
     <column>bus3</column>
  </row>
  <row>
     <column>Company Description</column>
     <column>tar1</column>
     <column>tar2</column>
     <column>tar3</column>
  </row>

Any help would be greatly appreciated.

Thanks in advance

Anandh

anandhkumar · January 12, 2010, 1:06pm

El Martes, 12 de Enero de 2010, Anandh K. escribiÃ³:

  <row>
  </row>

     <column>tar3</column>
  </row>
Any help would be greatly appreciated.

Of course it can be manipulated to get your desired output. You must use
a XML
parser (I recommend Nokogiri), inspect the XML by extracting/moving the
nodes
you are interested in and generating the new XML.

anandhkumar · January 12, 2010, 2:57pm

Hi Anandh,

I’ve cross-posted my reply to nokogiri-talk, which is where followup
questions are probably best sent.

On Tue, Jan 12, 2010 at 6:44 AM, Anandh K.
[email protected]wrote:

 <row>
 </row>

    <column>tar3</column>
 </row>
Any help would be greatly appreciated.

This is straightforward if you know some XPath (see
xpath cover page) and Nokogiri.

I’ve posted a solution at:

gist.github.com

https://gist.github.com/flavorjones/275209

xml.rb

#! /usr/bin/ruby
# in response to ruby-talk email of 2010-01-12 from Anandh Kumar

xml = <<EOX
<root>
     <row>
        <column>Business Strategy</column>
        <column>bus1</column>
     </row>
     <row>

This file has been truncated. show original

The general idea is that we find the nodes we care about, and then build
a
new document with those contents.

Cheers,
-mike

anandhkumar · January 13, 2010, 1:31pm

Anandh
Â
Apply an XSLT with Ruby On Rails.
Please refer
http://snippets.dzone.com/posts/show/4615
Â
http://www.xml.com/pub/a/2007/01/17/making-xml-in-a-rails-app-xml-builder.html
Â
thanks
Deepak

— On Tue, 1/12/10, Anandh K. [email protected] wrote:

From: Anandh K. [email protected]
Subject: XML Manipulating
To: “ruby-talk ML” [email protected]
Date: Tuesday, January 12, 2010, 3:44 AM

Hi everybody

Â Â Â Â Can anybody there help me in solving the following issue.

Consider the XML

Â Â Â
Â Â Â Â Â Â Business Strategy
Â Â Â Â Â Â bus1
Â Â Â
Â Â Â
Â Â Â Â Â Â Company Description
Â Â Â Â Â Â tar1
Â Â Â
Â Â Â
Â Â Â Â Â Business Strategy
Â Â Â Â Â bus2
Â Â Â
Â Â Â
Â Â Â Â Â Company Description
Â Â Â Â Â tar2
Â Â Â
Â Â Â
Â Â Â Â Â Â Business Strategy
Â Â Â Â Â Â bus3
Â Â Â
Â Â Â
Â Â Â Â Â Â Company Description
Â Â Â Â Â Â tar3
Â Â Â

Can this xml be parsed and manipulated in ruby as

Â Â Â
Â Â Â Â Â Â Business Strategy
Â Â Â Â Â Â bus1
Â Â Â Â Â Â bus2
Â Â Â Â Â Â bus3
Â Â Â
Â Â Â
Â Â Â Â Â Â Company Description
Â Â Â Â Â Â tar1
Â Â Â Â Â Â tar2
Â Â Â Â Â Â tar3
Â Â Â

Any help would be greatly appreciated.

Thanks in advance

Anandh

anandhkumar · January 20, 2010, 1:14pm

<?xml version="1.0"?> Business Strategy aaaa aaaaa gggg <?xml version="1.0"?> Company Description bbbb bbbb fhghj <?xml version="1.0"?> Business Strategy aaaa aaaaa gggg <?xml version="1.0"?> Company Description bbbb bbbb fhghj

Consider the above XML. Is there anyway to remove “<?xml version="1.0"?>” and also the duplicate block with same data.

For example consider the following identical blocks

<?xml version="1.0"?> Business Strategy aaaa aaaaa gggg <?xml version="1.0"?> Business Strategy aaaa aaaaa gggg

The resulting xml should remove the duplicate block and should contain
only one.

Any help would be appreciated.

Thanks in Advance

Anandh

Anandh K. wrote:

Thanks mike. The solution solved my problem to a greater extent but with
one issue.

In the resulting solution which is as follows
Business Strategy bus1 bus2 bus3 Company Description tar1 tar2 tar3
Can you suggest me how can i avoid “<?xml version="1.0"?>”.

If i give some thing like this

puts new_doc.to_xml(:dasherize => false, :skip_instruct=>true)

Ruby compiler threw argument error.

Any help would be appreciated.

Thanks

Anandh

Mike D. wrote:
Hi Anandh,

I’ve cross-posted my reply to nokogiri-talk, which is where followup
questions are probably best sent.

On Tue, Jan 12, 2010 at 6:44 AM, Anandh K.
[email protected]wrote:
 <row>
 </row>

    <column>tar3</column>
 </row>
Any help would be greatly appreciated.
This is straightforward if you know some XPath (see
xpath cover page) and Nokogiri.

I’ve posted a solution at:

xml.rb · GitHub

The general idea is that we find the nodes we care about, and then build
a
new document with those contents.

Cheers,
-mike

anandhkumar · January 20, 2010, 10:06am

Thanks mike. The solution solved my problem to a greater extent but with
one issue.

In the resulting solution which is as follows

Business Strategy bus1 bus2 bus3 Company Description tar1 tar2 tar3

Can you suggest me how can i avoid “<?xml version="1.0"?>”.

If i give some thing like this

puts new_doc.to_xml(:dasherize => false, :skip_instruct=>true)

Ruby compiler threw argument error.

Any help would be appreciated.

Thanks

Anandh

Mike D. wrote:

Hi Anandh,

I’ve cross-posted my reply to nokogiri-talk, which is where followup
questions are probably best sent.

On Tue, Jan 12, 2010 at 6:44 AM, Anandh K.
[email protected]wrote:
 <row>
 </row>

    <column>tar3</column>
 </row>
Any help would be greatly appreciated.
This is straightforward if you know some XPath (see
xpath cover page) and Nokogiri.

I’ve posted a solution at:

xml.rb · GitHub

The general idea is that we find the nodes we care about, and then build
a
new document with those contents.

Cheers,
-mike

anandhkumar · January 22, 2010, 7:38am

Dear Mike

Can this be done using Hpricot. I tried doing with Hpricot. But

Hpricot doesnot support xpath. It support something called “search”.With
that too I could not get my desired result since it doesnot support
“following-sibling” property.

Any help would be appreciated.

Thanks

Anandh

Mike D. wrote:

Hi Anandh,

I’ve cross-posted my reply to nokogiri-talk, which is where followup
questions are probably best sent.

On Tue, Jan 12, 2010 at 6:44 AM, Anandh K.
[email protected]wrote:
 <row>
 </row>

    <column>tar3</column>
 </row>
Any help would be greatly appreciated.
This is straightforward if you know some XPath (see
xpath cover page) and Nokogiri.

I’ve posted a solution at:

xml.rb · GitHub

The general idea is that we find the nodes we care about, and then build
a
new document with those contents.

Cheers,
-mike