Difference between revisions of "SET SEPARATOR"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
==Purpose== | ==Purpose== | ||
Change the character used to mark thousands | Change the character used to mark thousands | ||
Line 29: | Line 25: | ||
==Products== | ==Products== | ||
− | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|SEPARATOR]] | [[Category:Set_Commands|SEPARATOR]] | ||
+ | [[Category:Numeric Data]] | ||
+ | [[Category:Numeric Data Set Commands]] |
Latest revision as of 15:27, 25 November 2009
Purpose
Change the character used to mark thousands
Syntax
SET SEPARATOR TO [<expC>]
See Also
SET DECIMALS, SET POINT, SET PRECISION
Description
The SET SEPARATOR TO command changes the thousand mark character from a comma to the character specified by <expC> and is used in conjunction with a picture statement or clause. This command, along with SET POINT, is typically used to change the way a decimal is written from 123,456.98 to 123.456,98. In order for the SET SEPARATOR command to work properly when outputting with @...SAYS or ?, a picture must be used that conforms to the setting of SET POINT and SET SEPARATOR. If <expC> is more than one character long, the SET SEPARATOR command will only use the first character in the string. When used without a character expression, the SET SEPARATOR command changes the thousand mark character back to the default of a comma (,).
Example
set point to "," set separator to "." @1,1 say ord_value picture "999.999.999.99" 1.234.567,89
Products
Recital Server, Recital