escaping ampersands in replace function

Play the video

Subject: escaping ampersands in replace function
From: Mario Madunic <hajduk@xxxxxxxx>
Date: Tue, 4 Sep 2007 08:58:51 -0700

I'm trying to replace all ampersands in a string to 'and'. Long story short:
XSLT counts length as 1 but SQL Server counts length as 5, so need to replace.

I'm using XSLT2's replace function against a string but am having problems
escaping the ampersand. I've tried various methods, but with no luck.

replace($l_TempString, '\&amp;amp;', 'and')

Any insight will be appreciated.

Thanks

Marijan (Mario) Madunic

Current Thread
escaping ampersands in replace function Mario Madunic - 4 Sep 2007 15:59:13 -0000 <= Andrew Welch - 4 Sep 2007 16:06:02 -0000 David Carlisle - 4 Sep 2007 16:07:19 -0000 Mario Madunic - 4 Sep 2007 16:43:19 -0000 David Carlisle - 4 Sep 2007 16:52:25 -0000

<- Previous	Index	Next ->
Re: Variable in xsl:import hr, Bernie	Thread	Re: escaping ampersands in re, Andrew Welch
Re: Variable in xsl:import hr, G. Ken Holman	Date	Re: escaping ampersands in re, Andrew Welch
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >