parse xml

28 views
Skip to first unread message

Дмитрий Соколов

unread,
Feb 22, 2016, 4:57:27 AM2/22/16
to Scriptella ETL
 I found an example of converting XML to CSV,In the example used, this structure

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Demo input for ETL -->
<CATALOG>
    <CD>
        <TITLE>Empire Burlesque</TITLE>
        <ARTIST>Bob Dylan</ARTIST>
        <COUNTRY>USA</COUNTRY>
        <COMPANY>Columbia</COMPANY>
        <PRICE>10.90</PRICE>
        <YEAR>1985</YEAR>
    </CD>
</CATALOG>

How can I convert the XML file that has the following structure

<CATALOG>
    <CD title='Empire Burlesque' artist='Bob Dylan'  country='USA'/>
    .............
        <CD title='Empire Burlesque' artist='Bob Dylan'  country='USA'/>
</CATALOG>

How do I get to the values of attributes in XML?
 
Reply all
Reply to author
Forward
0 new messages