Difference between revisions of "SET SEPARATOR"

From Lianjapedia
Jump to: navigation, search
 
 
(3 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
 
  
 
==Syntax==
 
==Syntax==
 
SET SEPARATOR TO [<expC>]
 
SET SEPARATOR TO [<expC>]
 
  
 
==See Also==
 
==See Also==
[[SET DECIMALS]], [[SET POINT]], [[SET PRECISION]]
+
[[SET DECIMALS]], [[SET POINT]]
 
+
  
 
==Description==
 
==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 (,).
 
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==
 
==Example==
Line 23: Line 19:
 
</code>
 
</code>
  
 
==Products==
 
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 10:07, 4 February 2013

Purpose

Change the character used to mark thousands

Syntax

SET SEPARATOR TO [<expC>]

See Also

SET DECIMALS, SET POINT

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