Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get rid of '0' in character string...
Message
From
11/07/2000 12:07:15
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00390434
Message ID:
00390778
Views:
9
http://support.microsoft.com/support/kb/articles/Q247/4/94.ASP

>>I only use the ALLTRIM(STR()) format when I know I'm dealing with integers. If I have decimals, I pass the extra parameters to STR() that specify the number of decimals. I'm kind of leary of switching to TRANSFORM() after reading the Knowledge Base article I mentioned previously. Did you take a look at that?
>
>Not yet, since you didn't provide a convenient link (I'm a lazy person), but I'm doing right now...
>>
>>>>Is there any particular reason why you use TRANSFORM() instead of ALLTRIM(STR())? I just searched the MS Knowledge Base and found the following article that mentions some problems with TRANSFORM(): Q247494. I've just always used ALLTRIM(STR()), and never really looked at anything else, so I didn't know if there was a benefit to using TRANSFORM() other than less typing.
>>>
>>>One function instead of two, and also look to the difference between:
>>>lnNumber=2.345678901
>>>?transform(lnNumber)
>>>?alltrim(str(lnNumber))
>>>
>>>>>>There may be a better way, but of the top of my head:
>>>>>>
>>>>>>ALLTRIM(STR(VAL( LEFT( oJC.IssMonth, 2 ) )))
>>>>>
>>>>>Hi Jonathan,
>>>>>
>>>>>With VFP6.0 I make a habit to use transform() instead of alltrim(str())
>>>>>
>>>>>
>>>>>>>Hi everybody,
>>>>>>>
>>>>>>>I have this string in my report:
>>>>>>>SUBSTR(oJC.IssMonth,3) +' YEAR-TO-DATE RECAP THRU ISSUE ' +LEFT(oJC.IssMonth,2)
>>>>>>>
>>>>>>>left(oJC.IssMonth,2) would be '07', '08', etc. I would like to print just '7' or '8' in my Report. What would be the simplest way to achive this?
>>>>>>>
>>>>>>>Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform