Page 1 of 1
unable to read Xml file
Posted: Fri Jan 16, 2009 4:38 pm
by krishna81
Hi,
i am unable to read the following data through xml input stage.
<?xml version="1.0" encoding="UTF-8"?>
<XML>
<product>
<number>123</number>
<color><blue></color>
<location>A</location>
</product>
</XML>
Here i have issue with <color><blue></color>.
Thanks
Kris
Posted: Fri Jan 16, 2009 5:25 pm
by chulett
What issue, exactly? Does everything else parse out, just not that? Is there an error or warning generated? You really haven't given us any information about your job either - for example the XPath Expressions you are using in the XML Input stage, in particular for this element.
Posted: Sat Jan 17, 2009 4:34 pm
by eostic
Yes...what is the symptom? If <blue> is truly the value of the element, then it should have been escaped (the carets should not be visible like that in the raw xml)....you should instead see < and >
Ernie
Posted: Mon Jan 19, 2009 10:45 am
by krishna81
I am not getting any warnings/errors.But it stop reading from <color><blue></color>.
<blue> is not an element it is data for color element.
Posted: Mon Jan 19, 2009 10:52 am
by chulett
You've got bad XML. As noted, it should look like this:
<color><blue></color>
Ask whomever supplied / generated it to correct the problem.