Programming

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>
<sku>838373736</sku>
<price>1.26</price>
</Item>
<Item>
<sku>842374823</sku>
<price>2.99</price>
</Item>
</Items>
</Txn>
<Txn>
<Date>120504</Date>
<id>89</id>
<Items>
<Item>
<sku>36433637</sku>
<price>2.36</price>
</Item>
</Items>
</Txn>

I would want this xml to look like the following in the pipe delimited format,
120504|99|838373736|1.26
120504|99|842374823|2.99
120504|89|36433637|2.36

Have u tried Apache Xerces ??
I guess u need to parse XML using DOM or SAX
to refine to the format u would need ;