>I have SQL command which returns the character value of a numeric file STR(A,10,0). A can be from 1 to 999999999. I would like to display as 1234567 as 1,234,567. If I use TRANSFORM(STR(A,10,0),'@R '9,999,999,999;) I get extra commas, i.e 1234 is displayed as ' , , 1,234'. Is it possible to get rid of the extra commas? If so what is the correct syntax for the TRANSFORM command or if it is the wrong command what is the correct command.
You should not use STR in the transform, and the picture is completely wrong, you should check it, it should be like
TRANSFORM(A,'@R 9,999,999,999')
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges