Difference between revisions of "TRANSFORM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform picture formatting
 
Function to perform picture formatting
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[IIF()]], [[STR()]]
+
[[@...GET]], [[IIF()]], [[STR()]]
  
  
Line 33: 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