How to TRANSFORM a number? 2

[dsandlin]

I have tried to decipher the help file on the TRANSFORM function, but have failed to figure out how to do the simplest thing. I want to convert a number into a string with four digits using leading zeroes.

There are no examples on how to use the format codes (e.g., @L).

What is the format to turn 3 into '0003'?

Is it really necessary to use something like
RIGHT('0000000' + ALLTRIM(STR(3)), 4)?
That seems like overkill with a performance hit to me.

Does anyone know of a good reference for the TRANSFORM function?


Regards, Dick

 

[Mark826]

You can also use PADL(3, 4, "0") to get the same results.

 

[JRB-Bldr]

One way "to turn 3 into '0003'"...

 mnThree = 2
 mcThree = PADL(ALLTRIM(STR(mnThree)),4,"0")

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[rgbean]

Dick,
You were close, try:

?TRANSFORM(3,"@L 9999")

Rick

 

[Mike Lewis]

Or yet another way:

RIGHT(STR(MyNumber)+1000),4)

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[dsandlin]

Thanks, Rick, for the answer that I was looking for. I gave you a star for that one.

Now, does anyone know of a good reference for finding that kind of information? (outside of Tek-Tips - which is rapidly becoming my favorite reference for all questions...)

Mark, JRB, and Mike, thanks for good alternate solutions. I was trying to find a way to avoid more than one function call. Mike, you cut it down to two at least -- pretty close.


Regards, Dick