RE: [xsl] Xslt 2 stripping out non-numbers

Subject: RE: [xsl] Xslt 2 stripping out non-numbers
From: "Jim Neff" <jneff@xxxxxxxxxxxxxxx>
Date: Tue, 19 Apr 2005 13:53:30 -0400
Charles, 

The characters to be removed could be anything, upper, lower, hyphens,
spaces ... Anything NaN.

Thanks for the help thus far.

--Jim

> -----Original Message-----
> From: cknell@xxxxxxxxxx [mailto:cknell@xxxxxxxxxx] 
> Sent: Tuesday, April 19, 2005 1:22 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE: [xsl] Xslt 2 stripping out non-numbers
> 
> Will the characters to be removed always be upper-case letters?
> --
> Charles Knell
> cknell@xxxxxxxxxx - email
> 
> 
> 
> -----Original Message-----
> From:     Jim Neff <jneff@xxxxxxxxxxxxxxx>
> Sent:     Tue, 19 Apr 2005 13:22:30 -0400
> To:       <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
> Subject:  [xsl] Xslt 2 stripping out non-numbers
> 
> Greetings,
> 
> I need to strip out non-numerical values from a string.  
> 
> Here is a sample input value:  TUV0062
> 
> And what I want is :  0062  (or just 62)
> 
> Here's what I've tried so far:
> 
> for $i in tokenize(state_license_number, '\.') return xs:string( if
> (string(number(.)) = 'NaN') then '' else $i)
> 
> But this does not work.  I get an empty string as a result
> 
> If I do this:
> 
> for $i in tokenize(state_license_number, '\.') return xs:string($i)
> 
> I get the whole string back so I know my "for" statement is returning
> something.
> 
> What is the correct way to do this using XSLT 2?
> 
> Thanks,
> Jim

Current Thread