Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transform()
Message
From
19/12/2016 01:08:20
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01645510
Message ID:
01645516
Views:
56
>Hi,
>
>I have a code in the program that converts a string of numbers (not a number but a string of numbers) according to the second parameter of Transform(). For example,
>
>nNumber = 67849
>cMask = 'M XXXXXXXXXX'
>cNumber = transform( alltrim(str(nNumber)) + "@R" + cMask)
>*-- the result, cNumber, should be 'M 67849'
>
>
>The above works unless the cMask is 'A XXXXXXXXXX'
>
>Why does the 'A' make a difference?
>
>TIA

I presume you've made a few typos in your example:
cNumber = transform( alltrim(str(nNumber)), "@R " + cMask)
(i.e. you probably wanted to have: 1. a comma rather than a "+" between the expression and the format code; 2. a space between the "@R" and character mask)

IIRC in the case when the first parameter to TRANSFORM() is a string value, "A" in a mask would be the equivalent to "X" -- thus variable cNumber would contain the value "6 7849" rather than "A 6789"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform