Difference between revisions of "TRANSFORM()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=TRANSFORM()=
 
 
 
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform picture formatting
 
Function to perform picture formatting
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[STR()]], [[IIF()]]
+
[[@...GET]], [[IIF()]], [[STR()]]
  
  
Line 36: 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 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