Salesforce

Directives for Numeric Pictures (Magic xpa 3.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Directives for Numeric Pictures (Magic xpa 3.x)

The tables below provide a list of positional directives for Numeric pictures.

Numeric Positional Directives

Directive

Description

#{n}

A placeholder for a digit.

.

Indicates the location of the decimal separator, as defined in the Environment dialog box.

Numeric Functional Directives

Directive

Name

Description

A

Auto Skip

Instructs Magic xpa to move automatically to the next variable when the user has entered characters, filling up all of the available space in the current field.

Default: No

Platform specific: This directive is not supported for mobile devices.

Exceptions: Auto Skip is not supported for Browser Client tasks.

N

Negative

Instructs Magic xpa that this variable may contain negative values. If Yes is specified, Magic xpa automatically enlarges the display size of the picture, as portrayed by the template, to enable a sign to be displayed.

Default: No

C

Commas

Instructs Magic xpa to insert commas as thousands separators in the variable. If you specify Yes, Magic xpa automatically enlarges the display size of the picture, as portrayed by the template, to include positions for commas. Commas may be replaced by any other character as specified in the Thousands Separator variable of the Environment dialog box.

Default: No

L

Left justify

Instructs Magic xpa to left-justify the variable value when displayed.

Default: No (right-justified)

Pc

Pad fill

Instructs Magic xpa to fill the part of the displayed variable that does not contain digits with the character specified in “Character:” If you do not specify a character, the variable is padded with blanks.

Default: No

Zc

Zero fill

Instructs Magic xpa to fill the entire displayed variable with the Character value if its value is zero. If you do not specify any character, the variable is padded with blanks.

Default: No

-c{,S};

Negative sign

Lets you enter a prefix and/or suffix that will be displayed when the field is negative.

If you want to display a string instead of the conventional minus sign (-) to indicate a negative value, use the - directive followed immediately by the new sign prefix, a comma, the new sign suffix, and then a semicolon (;). To display a string at the end of a negative value, type the string you want in the Suffix parameter.

For example:

  • The picture N4.3+,CR;-,DB; specifies that positive numbers should be suffixed with the string CR and negative numbers with the string DB.

  • The picture N10.2C+$;-$-; specifies that both negative numbers and positive numbers will be prefixed with a $ sign.

This directive is used often to display currency symbols.

+c{,S};

Positive sign

Lets you enter a prefix and/or suffix that will be displayed when the field is positive.

If you want to display a string instead of the conventional plus sign (+) to indicate a positive value, use the + directive followed immediately by the new sign prefix, a comma, the new sign suffix, and then a semicolon (;). To display a string at the end of a positive value, type the string you want in the Suffix parameter.

For example:

  • The picture N4.3+,CR;-,DB; specifies that positive numbers should be suffixed with the string CR and negative numbers with the string DB.

  • The picture N10.2C+$;-$-; specifies that both negative numbers and positive numbers will be prefixed with a $ sign.

This directive is used often to display currency symbols.

For variables with the Numeric attribute, the # directives, the count values, and the optional decimal position character define the number of digits in the whole part and in the decimal part. This in turn defines the default storage field model and length of the variable.

Note:

n - represents the count value

{ } - represents an optional part

c - represents a mask character. To use a directive character, for example X, where c appears, preface it with a backslash, as in \X.

The bottom area of the dialog box shows the exact template of the variable as it will be displayed, that is, which mask characters are displayed and how many positions the variable will occupy on screen or report forms.

Related Topics

Reference
Attachment 
Attachment