Re: [xsl] Extract only numeric value

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Extract only numeric value
From: Abel Braaksma <abel.online@xxxxxxxxx>
Date: Thu, 24 May 2007 10:09:58 +0200

Hi JS,

This is a faq, though the faq entry is hidden behind the name "check for integer", it actually shows how to use a regex to match an integer. It should be easy to extract the integer part based on these regexes: http://www.dpawson.co.uk/xsl/rev2/datatypes.html#d15622e974

If you don't care about the fuzz, you can also use simply (\d+) which will greedily grab the number.

Or you can do tokenize($var, '\D+') which will give you all numbers. You may want to change that to tokenize($var, '\D+')[.] to remove empty items of the sequence.

Cheers,
-- Abel Braaksma

J. S. Rawat wrote:

Dear All,
I would like a help about to extract numeric value.

Input
<year>2007a</year>
Output
<year>2007</year>

Thanks in advance for your kind help.
...JSR

Current Thread
Extract only numeric value J. S. Rawat - 24 May 2007 07:49:50 -0000 Mukul Gandhi - 24 May 2007 08:10:29 -0000 Jeff Sese - 24 May 2007 08:11:17 -0000 Abel Braaksma - 24 May 2007 08:12:38 -0000 <= J. S. Rawat - 24 May 2007 08:33:58 -0000

<- Previous	Index	Next ->
Re: Extract only numeric valu, Jeff Sese	Thread	Re: Extract only numeric valu, J. S. Rawat
Re: Extract only numeric valu, Jeff Sese	Date	Re: Extract only numeric valu, J. S. Rawat
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >