Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

XSL filter to convert XML to CSV

3 views

Skip to first unread message

alexre2005

unread,

Nov 25, 2009, 9:58:52 AM11/25/09

Hi all,

I am very new in XML/XSL. I am using Apache XML Project – Xalan to
convert the XML file to CSV so I have to write XSL filter for the
following xml file

<?xml version="1.0" encoding="UTF-8"?>
<Applications>
<PL_SQL_LIBRARIES>
<ALEX_drag_F__pitsscon_users_alex_olb>
<Program_Unit>
<OG>
<valid>At line 31 pos(7) Run_Product (GRAPHICS, display, SYNCHRONOUS,
BATCH, FILESYSTEM, plist, item);</valid>
</OG>
</Program_Unit>
</ALEX_drag_F__pitsscon_users_alex_olb>
<ALEX_og___F__pitsscon_users_alex_olb>
<Program_Unit>
<OG>
<valid>At line 31 pos(7) Run_Product (GRAPHICS, display, SYNCHRONOUS,
BATCH, FILESYSTEM, plist, item);</valid>
</OG>
</Program_Unit>
</ALEX_og___F__pitsscon_users_alex_olb>
</PL_SQL_LIBRARIES>
<FORM_MODULES>
<ALEX_about____F__pitsscon_users_alex_fmb>
<Program_Unit>
<SETUPLOOKUP>
<valid>Read_image_file -> At line 16 pos(2) Read_Image_File( '\
\PDMAIN\\BMP\\PdAbout.BMP', 'BMP',
'LOOKUP.PDABOUT');</valid>
</SETUPLOOKUP>
</Program_Unit>
</ALEX_about____F__pitsscon_users_alex_fmb>
<ALEX_aboutpd__F__pitsscon_users_alex_fmb>
<Program_Unit>
<SETUPLOOKUP>
<valid>Read_image_file -> At line 20 pos(2) Read_Image_File( '\
\PDMAIN\\BMP\\TDSLOGOGEN1.BMP', 'BMP',
'LOOKUP.TDSLOGOGEN1');</valid>
</SETUPLOOKUP>
</Program_Unit>
</ALEX_aboutpd__F__pitsscon_users_alex_fmb>
</FORM_MODULES>
</Applications>

The expected result in CSV file should be:

'PL_SQL_LIBRARIES','ALEX_drag_F__pitsscon_users_alex_olb','OG','At
line 31 pos(7) Run_Product (GRAPHICS, display, SYNCHRONOUS, BATCH,
FILESYSTEM, plist, item);'
'PL_SQL_LIBRARIES','ALEX_og___F__pitsscon_users_alex_olb','OG','At
line 31 pos(7) Run_Product (GRAPHICS, display, SYNCHRONOUS, BATCH,
FILESYSTEM, plist, item)'
'FORM_MODULES','ALEX_about____F__pitsscon_users_alex_fmb','SETUPLOOKUP','Read_image_file
-> At line 16 pos(2) Read_Image_File( '\PDMAIN\BMP\PdAbout.BMP',
'BMP', 'LOOKUP.PDABOUT');'

The names of nodes could be different in XML.

Thank you in advance

Martin Honnen

unread,

Nov 25, 2009, 10:13:43 AM11/25/09

alexre2005 wrote:
> Hi all,
>
> I am very new in XML/XSL. I am using Apache XML Project ï¿½ Xalan to

For some element nodes you seem to want to output the element name, for
other not.
It is not clear what determines whether the name of an element should be
output or not.
Please clarify, otherwise it is hard to implement your requirements.

Martin Honnen --- MVP XML
http://msmvps.com/blogs/martin_honnen/

0 new messages