Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01645510
Message ID:
01645534
Views:
49
>>>>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
>>>
>>>Hi,
>>>
>>>following works for me:
>>>
>>>
>>>lcMask = "9 9999"
>>>lnNumber =67849
>>>? transform( m.lnNumber , "@R "+ m.lcMask)
>>>
>>>Regards,
>>>Koen
>>
>>Thank you, Koen. The reason my code didn't work is because I have a letter (specifically 'A') in my lcMask.
>
>Because "A" is valid mask letter:
>Check InputMask in HELP.
>The same is with letter "W"

Thank you. I will be changing my approach from "@R " since I cannot tell customers what letter they can or cannot use.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View