How can I access the data (CDATA) in this xml node with Xpath?

Question

I have next XML:

<?xml version="1.0" encoding="UTF-8"?>
<mailAndMessageSettings>
    <settings>
        <add key="Url" value=""/>
        <add key="UserName" value=""/>
        <add key="Password" value=""/>
    </settings>
    <mail>
        <subject>      
            Mp3 Submission
        </subject>
        <body>
            <![CDATA[
                <meta http-equiv="Content-Type" content="text/html; charset="utf-8""/>
                <head></head>

                <body>
                <p>Hi,</p>

                <p>Please find the attached mp3</p>

                <p><a href="mymp3.mp33">here</a></p>

                <p>Regards,</br>
                Pete</p>

                </body>
                </html> 
            ]]>
        </body>
    </mail>    
</mailAndMessageSettings>

And I want to use an XPath:

/mailAndMessageSettings/mail/body

However when I use it, it is selecting everything from the first body tag (correct) to the body tag inside the html rather than the body tag in the XML document...

How can I select all of the CDATA inside the body XML without the CDATA tag included?

abatishchev · Accepted Answer · 2011-05-12 14:57:36Z

1

You need to get CDATA node, load it to separate XmlDocument, and call XPath query again.

answered May 12, 2011 at 14:57

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Exitos · Accepted Answer · 2011-05-12 15:05:43Z

1

So actually I just changed the outer body tag to bodyHtml tag instead.... and then use:

/mailAndMessageSettings/mail/bodyHtml

answered May 12, 2011 at 15:05

Exitos

29.9k39 gold badges128 silver badges179 bronze badges

Comments

onteria_ · Accepted Answer · 2011-05-12 14:56:04Z

0

The parser is only going to make the CDATA accessible as text, because that's what it's used for.

If you aren't validating this, and you don't appear to be declaring it as HTML (which would restrict the presence of double body tags), I'm not sure why you need the CDATA declaration. If it's because it's dynamically generated, and you're not sure what might be generated in the strings, you should be wrapping the text in the dynamically generated html in CDATA instead.

answered May 12, 2011 at 14:56

onteria_

70.9k7 gold badges73 silver badges64 bronze badges

Comments

ceving · Accepted Answer · 2011-05-12 14:59:40Z

0

Use /mailAndMessageSettings/mail/body/text().

answered May 12, 2011 at 14:59

ceving

24.2k15 gold badges120 silver badges201 bronze badges

Collectives™ on Stack Overflow

How can I access the data (CDATA) in this xml node with Xpath?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related