Convert XML Data to String / text

Question

Post reply

Convert XML Data to String / text

Vijji-429978

SSC Eights!

Points: 983
More actions
June 17, 2009 at 1:00 pm

#135219

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

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

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

LutzM SSC Guru Points: 107049 More actions · Answer 1

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]

Vijji-429978 SSC Eights! Points: 983 More actions · Answer 2

It has to be in the Text format.

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

Thank you,

Regards

Vijji

LutzM SSC Guru Points: 107049 More actions · Answer 3

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]

Vijji-429978 SSC Eights! Points: 983 More actions · Answer 4

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

LutzM SSC Guru Points: 107049 More actions · Answer 5

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]

OTF SSCertifiable Points: 6104 More actions · Answer 6

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

LutzM SSC Guru Points: 107049 More actions · Answer 7

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]

OTF SSCertifiable Points: 6104 More actions · Answer 8

ah right. Thanks for clearing that up, Lutz.

Chim Kalunta