Here's an example using Text::CSV and XML::Twig to get you started:
use strict; use warnings; use Text::CSV; use XML::Twig; my $CSV = Text::CSV->new(); my $XML = XML::Twig->new( twig_handlers => { product => sub { my @data; push @data, $_->att('description'); my $c_i = $_->first_child('catalog_item'); push @data, $c_i->att('gender'); ### Gather the other fields here, then... $CSV->print(*STDOUT, \@data); print "\n"; }, }, pretty_print => 'indented', ); $XML->parsestring(*DATA); __DATA__ <?xml version="1.0"?> <?xml-stylesheet href="catalog.xsl" type="text/xsl"?> <!--<!DOCTYPE catalog SYSTEM "catalog.dtd">--> <catalog> <product description="Cardigan Sweater" product_image="cardigan.jpg" +> <catalog_item gender="Men's"> <item_number>QWZ5671</item_number> <price>39.95</price> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color +_swatch> </size> <size description="Large"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color +_swatch> </size> </catalog_item> <catalog_item gender="Women's"> <item_number>RRX9856</item_number> <price>42.50</price> <size description="Small"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color +_swatch> </size> <size description="Medium"> <color_swatch image="red_cardigan.jpg">Red</color_swatch> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color +_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatc +h> </size> <size description="Large"> <color_swatch image="navy_cardigan.jpg">Navy</color_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatc +h> </size> <size description="Extra Large"> <color_swatch image="burgundy_cardigan.jpg">Burgundy</color +_swatch> <color_swatch image="black_cardigan.jpg">Black</color_swatc +h> </size> </catalog_item> </product> </catalog>

In reply to Re^5: DBD:AnyData on Complex XML by eff_i_g
in thread DBD:AnyData on Complex XML by hmadhi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.