Convert XML Data to String / text

  • Hi

    How to convert XML data field to string / text.

    Example: data is stored in the field is:

    Test Ticket

    Thank you,

    Regards

     

    Thank you,

    Regards

    Vijji

  • What would be the output you're looking for?



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • It has to be in the Text format.

    I need to display this field in SRS report without XML tags.

    Thank you,

    Regards

    Vijji

  • It looks a little more like HTML file rather than XML structure.

    That's a slightly different story...

    You might want to have a look at the following article:

    http://www.databasejournal.com/scripts/article.php/3494196/Function-to-strip-HTMLASPPHP-tags-from-text.htm



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • Thx for the reply.

    Now it removes the tags.

    Now it looks like this:

    Test ticket   Thank you,   Regards    

    '&' represents next line, those still remains.

    Thx

    Regards

    Vijji

  • Well, I just used "strip html" as search criteria on this forums search box. So, no big deal. 😉

    Sometimes it's just a matter of finding/knowing the right search string to get the right answer...



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • This is probably more a question than it is an answer but, if the data is stored in an xml data type what stops you from just using any one of the xml data type methods to retrieve whatever values you want from your xml?

    Chim Kalunta

  • The data as provided in the original post is in html format rather than xml type.

    The xml type gives you a data structure whereas html usually includes format information as well (e.g. for text in bold style).

    You'd need two different versions of receiving the value for the text depending on the format ( text here had to be queried different than text here ).



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • ah right. Thanks for clearing that up, Lutz.

    Chim Kalunta

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply