Difference between revisions of "TRANSFORM()"

From Lianjapedia
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 7: Line 7:
 
==See Also==
 
==See Also==
 
[[IIF()]], [[STR()]]
 
[[IIF()]], [[STR()]]
 
  
 
==Description==
 
==Description==
Line 24: Line 23:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Expressions and Type Conversion]]
+
[[Category:Formatting Functions]]
[[Category:Expressions and Type Conversion Functions]]
+

Latest revision as of 08:29, 4 February 2013

Purpose

Function to perform picture formatting

Syntax

TRANSFORM(<exp>, <expC>)

See Also

IIF(), STR()

Description

The TRANSFORM() function allows formatting of <exp> using a picture string <expC>. TRANSFORM() returns a character string formatted as requested.

Example

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