Parsing XML Tags with Dot

[visvacfirvin]

Hi,
I'm trying to convert XML to CSV.
Is it possible to parse XML tag names with dots. For eg, we have the following structure.

Code: Select all

<?xml version="1.0" encoding="ISO-8859-1"?>
<books.shiporder>
<books.item>
<books.title>Empire Burlesque</books.title>
<books.note>Special Edition</books.note>
<books.quantity>1</books.quantity>
<books.price>10.90</books.price>
</books.item>
</books.shiporder>

I imported the table definintion using XML Table import utility. Now when i tried to read the XML file to convert into CSv, it throws the following error.

Code: Select all

 Syntax error: Error in "export"  operator: Error in operator arg: In field "books": Expected ";", got: ".", line 78

If i remove the dots from the tag and load the metadata & parse, its working fine.

Please let me know the solution, if you have solved this before.

Thanks,
Firvin

[ray.wurlod]

Removing the dots is the solution. Tags with dots do not count as "well-formed XML" and DataStage expects well-formed XML.

[visvacfirvin]

Oh..thts bad...We recieve bigger XML files with this format. I already have a solution in Java. I was exploring possibilities.

Anyways Thanks Ray!!!