picture

This function is deprecated, use the format function instead to determine the layout of text values.

This function formats a number according to the picture format ( mask ) specified in the second parameter.

The function picture has two input parameters:

  1. number, of type NUMBER.
  2. mask, of type TEXT.

This function yields a value of type TEXT.

Example

@( picture( 12345; "99999S" ) )

Result: 12345+

Note that the construction @ ( ) around the function means that the result of the function is displayed in the text. This construction must be used in a text part of a model document. The switch from ITP mode to text mode in a model document is made with the # characters. An ITP model document starts in text model, the #BEGIN makes the switch to ITP mode.

Other possibilities:

Getal

Masker

Resultaat

123.0

'99999'

'00123'

123.0

'ZZZZ9'

' 123'

123.0

'****9'

'**123'

0.0

'ZZZZ9'

' 0'

0.0

'ZZZZZ'

' 0'

0.0

'****9'

'****0'

0.0

'*****'

'*****'

123.0

'S9999'

'+0123'

123.0

'+9999'

'+0123'

123.0

'+9999'

' 0123'

123.456

'999.99'

'001.23'

123.456

'999V.99'

'123.46'

123456.0

'ZZZ,ZZZ,ZZ9'

' 123,456'

123456.0

'***,***,**9'

'****123,456'

123456.0

'-ZZ,ZZZ,ZZ9'

'- 123,456'

123456.0

'---,---,--9'

' , , 6'

123456.78

'$**,***,**9V.99'

'$***123,456.78'

123456.78

'$$$,$$$,$$9V.99'

'$$$,$$$,$$6.78'

1.23456

'S9V.9999ES99'

'+1.2346E+60'

1.23456

"S9V.9999KS99'

'+1.2346K+60'

1234.567

'-999.999,V99'

' 001.234,57'

1234.567

'-9.999E9'

'-1.2345E0'

123456.0

'9B9B9B9B9B9'

'1 2 3 4 5 6'

12345.0

'9.9.9.9.9.9'

'0.1.2.3.4.5'

12345.0

'99999S"

'12345-'

123.45

'999+'

'123 '

123.45

'999+'

'123+'

0.12

'ZZZ.V99'

' 0.12'

0.12

"ZZZV.99'

' 0.12'

1.23E4

'-9V.999ES9'

' 1.230E+4'

123456.0

"S9999VESZ9'

'3456EE+00'

1.23456.0

'-V.999E-99'

' .234E+56'