Subject: RE: 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: 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: 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
|