In XSLT using XPath

Question

if I have number like $999,999 I want to use a function to give me just 999999 without any other symbol.I tried substring(value,2) but that take of the $ how about the , Is there any idea to do that,

Linga Murthy C S · Accepted Answer · 2015-03-22 01:00:54Z

2

Use the following:

<xsl:value-of select="translate('$999,999', '$,', '')"/>

answered Mar 22, 2015 at 1:00

Linga Murthy C S

5,4323 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Saleh Makkawy Over a year ago

actually it works fine with me but how if the value I'm getting its attribute can I do it like this <xsl:value-of select="translate('@value', '$,', '')"/>

Linga Murthy C S Over a year ago

@SalehMakkawy Yes, you can.. Just get single quotes off @value so that it is evaluated, and not considered a literal string.

lsowen · Accepted Answer · 2015-03-22 01:00:26Z

0

I'm assuming the value is actually a string, instead of a number. If you are using XPath 2.0, you can use replace (eg replace(substring(value,2), ',', '')).

If you are using XPath 1.0 (more widely supported) you can using translate (eg translate(substring(value,2), ',', '')).

answered Mar 22, 2015 at 1:00

lsowen

3,8681 gold badge25 silver badges23 bronze badges

1 Comment

michael.hor257k Over a year ago

Your approach will fail in case of a negative amount, e.g. "-$123".

Collectives™ on Stack Overflow

In XSLT using XPath

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related