TRANSFORM()

From Lianjapedia
Revision as of 08:29, 4 February 2013 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
Retrieved from "https://www.lianja.com/doc/index.php?title=TRANSFORM()&oldid=7786"