Information générale
Catégorie:
Codage, syntaxe et commandes
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!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement