Performs MultiValue formatting of a string or numeric.
||The value to be formatted. An expression that resolves to a numeric value or a quoted string.
||The formatting code. A quoted string consisting of positional letter and number codes specifying the display format for exp.
function invokes the Caché MVBasic FMT
function, and returns the resulting value to the ObjectScript environment. Specify parameter values in MVBasic form. For further details refer to the Caché MultiValue Basic Reference
The following example formats 12345 as a fractional number by adding a decimal point and zero padding it with four fractional digits:
The following example formats 12345 as a fractional number. The decimal point is moved three positions to the left, and the result is rounded to two fractional digits:
The following example formats 12345 as a date. Note that it uses MultiValue date counting (where 1 = January 1, 1968) rather than Caché $HOROLOG
date counting (where 1 = January 1, 1841):
The following example formats 12345 as a right-justified string of ten characters, using ^ as a fill character: