mrc Documentation
michaels, ross & cole, ltd.
http://www.mrc-productivity.com/

Calculations in Servlets (mrc-Productivity Series Users Only)

Most calculations are created through the calculation option of the Application Options screen. These may use standard calculation functions and/or external objects to achieve the final result. In addition, there are certain reserved characters and special keywords, which may be used:

Reserved Characters

The characters &, %, :, + and ' ' (blank) have a specific purpose within the mrc calculation generator. Consequently, they cannot exist in their own right within a calculation definition.

However, in a servlet application it may be necessary to generate character strings, which contains these characters. To utilize these special characters, the following substitution values are available:

AMP_ = &

PCT_ = %

CLN_ = :

PLS_ = +

SPC_ = ' ' (blank space)

For example:

If I wanted, at run time, for the fields Product Number and RICKTEST to be separated with an ampersand, I would add “AMP_” to the calculation value, separated with a “+” between each field.

Substring within a Calculation

Sometimes it is necessary to build a substring within a calculation within an application. To do this, use this structure %FIELDNAME,A,B.

% -- Denotes to Productivity Series that you wish to utilize a Substring.

FIELDNAME – Choose the field name you wish to substring.

A – The starting position of your substring (1 denotes the first position).

B – The length of your substring.

For example, a calculation set up as below…

Will generate a substring of the Customer Name field, starting in the second position, going for 5 characters…