Replace decimal point with another value

bonekrusher · March 5th, 2007, 09:38 AM

Hi,

Is it possible to replace a decimal point with another value?

Input

<Element>1.2.3</Element>

Code:

<xsl:value-of select="replace(Element,'.', '_')"/>

Returns "___"

Desired HTML results

"1_2_3"

Thanks for the help.

joefawcett · March 5th, 2007, 09:57 AM

Sorry but I don't believe you :)
What XSLT processor gives this result? Are you certain that Element contains what you think it does?

--

Joe (Microsoft MVP - XML)

bonekrusher · March 5th, 2007, 10:06 AM

Hmm interesting. I am using XMLspy..

I verified the element does contian decimals....

bonekrusher · March 5th, 2007, 10:27 AM

I also ran it in SAXON 8.8 and get the same results...any thoughts?

joefawcett · March 5th, 2007, 10:50 AM

Post the XML and the XSLT, I will try it on my system.

--

Joe (Microsoft MVP - XML)

mhkay · March 5th, 2007, 10:52 AM

Use the translate function.

replace() uses regular expressions, in which "." matches any character. If you want to use replace, use "\." to match a period.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

bonekrusher · March 5th, 2007, 10:53 AM

Ok..I got it.

I used:

<xsl:value-of select="replace(Element,'\W+', '_')"/>

Thanks Michael,

"\." does the trick also.

Thanks a bunch

joefawcett · March 5th, 2007, 11:02 AM

Ok sorry I completely misread the post, I thought you were using the translate function [:)}. A trip to the opticians is in order.

Code:

translate(Element, '.', '_')

--

Joe (Microsoft MVP - XML)

bonekrusher · March 5th, 2007, 12:22 PM

No worries.. everyday I learn!