Embedded HTML tags in XML data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 30 Aug 2005 23:22 GMT

Hi.

I have queries that bring back recordsets from SQL 2000 that are being
converted to XML for display using XSLT templates.

The issue is that some of the verbose text has embedded tags. These
tags are being displayed on line. The end user does not want to see these
tags.

I have tried using the translate function (i.e.
translate(SystemClaimStatusDesc, ' ', ' '), but I am getting errors "'<',
hexadecimal value 0x3C, is an invalid attribute character. Line 167, position
168."

I know that somehow I have to convert the < to dec, but I am having no luck.

Can anyone assist?

Signature

Bryan Canterbury
Data Integration Specialist
Healthx, INC.

Reply to this Message

Pascal Schmitt - 31 Aug 2005 00:21 GMT

Hello!

> The issue is that some of the verbose text has embedded tags. These
> tags are being displayed on line. The end user does not want to see these
> tags.

You might want to copy the text directly, use
<xslt:value-of select=".." disable-output-escape="yes" />

> I have tried using the translate function (i.e.
> translate(SystemClaimStatusDesc, ' ', ' '), but I am getting errors "'<',
> hexadecimal value 0x3C, is an invalid attribute character. Line 167, position
> 168."

Use the matching Character Entities:

translate(SystemClaimStatusDesc, ' ', ' ')

Signature

Pascal

Reply to this Message

Oleg Tkachenko [MVP] - 31 Aug 2005 08:50 GMT

> Use the matching Character Entities:
>
> translate(SystemClaimStatusDesc, ' ', ' ')

Beware that translate function works on charcter basis and such
expression won't replace " " with space, instead it will replace <
characters with space and remove any b, r, and > characters.

Signature

Oleg Tkachenko [XML MVP, MCAD]
http://www.xmllab.net
http://blog.tkachenko.com

Reply to this Message

Embedded HTML tags in XML data

Free Magazines