General information
Category:
Coding, syntax & commands
Sorry, I had it in my head that you were using transform(). Try this.
?TRANSFORM('123456789',"@RT 999,999,999,999")
If you are using a text box then you need to put the RT in the format property.
>But if the data is a string (representing a number), how would I output it with commas without having to convert to a value?
>
>These values are bound to a cursor displayed in a grid.
>
>Thanks!
>
>>Tommy
>>
>>@R means to use mask for display only.
>>Changing your number to a val() displays correctly.
>>
>>>Me again!
>>>
>>>My brain must be fried today..... sigh...
>>>
>>>What I want to know is ...................
>>>
>>>Given a character string like '123456789', I want them to have commas in the correct place for output in the grid.
>>>
>>>Like... '1,234,567,890'
>>>
>>>I tried "@R9,999,999,999,999", but I got '1234567890'
>>>
>>>If I try "9,999,999,999,999", I get 1,345,789, ????????????????????
>>>
>>>I used to know this in another life... sigh....
>>>
>>>OK gurus... what am I doing wrong today (besides breathing)????
>>>
>>>
>>>Thanks!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only