Difference between revisions of "TRANSFORM()"
From Lianjapedia
Line 7: | Line 7: | ||
==See Also== | ==See Also== | ||
[[IIF()]], [[STR()]] | [[IIF()]], [[STR()]] | ||
− | |||
==Description== | ==Description== |
Revision as of 09:23, 16 November 2011
Contents
Purpose
Function to perform picture formatting
Syntax
TRANSFORM(<exp>, <expC>)
See Also
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