Difference between revisions of "TRANSFORM()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform picture formatting
 
Function to perform picture formatting
Line 10: Line 8:
  
 
==See Also==
 
==See Also==
[[IIF()]], [[STR()]]
+
[[@...GET]], [[IIF()]], [[STR()]]
  
  
Line 31: Line 29:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Expressions and Type Conversion]]
 
[[Category:Expressions and Type Conversion]]
 
[[Category:Expressions and Type Conversion Functions]]
 
[[Category:Expressions and Type Conversion Functions]]

Latest revision as of 14:15, 22 January 2010

Purpose

Function to perform picture formatting


Syntax

TRANSFORM(<exp>, <expC>)


See Also

@...GET, IIF(), STR()


Description

The TRANSFORM() function allows formatting of <exp> using a picture string <expC> in a similar way to the @...GET command. TRANSFORM() returns a character string formatted as requested. TRANSFORM() is particularly useful for redefining field widths when formatting reports or forms.

From version 9.3.3 onwards, the TRANSFORM() function can be used to return a numeric as a hexadecimal.


Example

total = 3001.23
? transform(total, "$$$$$9.99")
 $3001.23
 
? transform((0x1a * 2),"@0")
0x00000034


Products

Recital, Recital Server