Subject: RE: Display numeric string of the form 01W or 02Y
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Mon, 16 Nov 2009 09:26:22 -0000
|
> The string that I am trying to display is an entry in the
> database 'Tenor'. Its format is like 1W or 2W or 1Y.
> But, when I have to output it, it should be in the form 01W
> or 02W or 03W or 01Y or 10Y with a zero appended in the
> beginning. The number format cannot be used here.
Try:
replace($in, '^([0-9][A-Z])$', '0$1')
Regards,
Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay
|
Cart
