Hi,
I have data stored in cdata in one column in sql table.
After I retrieve it using data power i have 2 cdata added so i removed both of them using disable output escaping = true
Now I have the data in tags but it is in text format any suggestions to convert it to xml. I am not able to use any xml functions like parse etc since the data is in text.

step 1
data stored in sql -
<![CDATA[<Employee><Name>Nancy</Name><Age>25</Age></Employee>]]>

step 2
after using disable output escape i put in some tags as per my response schema

<EmployeeDetails>
<Address>USA</Address>
<Phone>1234</Phone>
<Employee1Details><Employee><Name>Nancy</Name><Age>25</Age></Employee><Employee1Details>
</EmployeeDetails>

We have text in Employee1Details tags so I am unable to parse it and have xml format instead of text.

Any suggestions please let me know.
Thanks in advance
Alisha

I don't understand what the problem, please explain it in more detail. So far I understand that you have some escaped markup in a CDATA section and that you use disable-output-escaping to unescape the markup and get elements in the serialized result of your XSLT stylesheet. If that is not the desired result then please show the XML you want to create instead.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog