+, -, *, /

Basic arithmetic operations

**

Exponentiation

number = ABS (number)

Absolute value:

Example:

|-3.4| = 3.4

number = INT (number)

number = AINT (number)

INT converts the number to "Integer".

AINT truncates the decimal places.

The result from INT and AINT is the same as long as the number is in the range of integer, meaning between -2^31 and 2^31.

Convert to "Integer" / Truncate decimal places

Example:

AINT(3.1) = 3
AINT(3.9) = 3
AINT(-3.9) = -3

number = ANINT (number)

number = NINT (number)

The two functions are identical.

Next real integer (rounding)

Example:

ANINT(3.1) = 3
ANINT(3.9) = 4
ANINT(4.5) = 5
ANINT(-3.9) = -4

number = DIM (number,number)

Positive difference:

As long as the first number is bigger than the second, the calculation is: number 1 - number 2; otherwise the result is 0.

Example:

DIM(8,4) = 4
DIM(4,8) = 0

number = SQRT (number)

Square root

number = EXP (number)

Exponential function

number = LOG (number)

Natural logarithm

number = LOG10 (number)

Logarithm base 10

number = MAX (...)

MAX (A1, A2, A3,…) 

Maximum value of parameters

number = MIN (...)

MAX (A1, A2, A3,…) 

Minimum value of parameters

number = MOD (number,number)

Remainder calculation:

A – INT (A/P)*P

Example

MOD(11,4) = 3
11 - (INT(11/4)*4) = 11 - 2*4 = 3
11 / 4 == 2 Rest 3

number = SIGN (number,number)

Sign transfer: |A| signum (B)

SIGN(A,B) means that the return of the value of A is given with the prefix of B.

Example:

SIGN(10,1)   =  10
SIGN(10,-1)  = -10

SIGN(-10,1)  =  10
SIGN(-10,-1) = -10

number = SIN (number)

Sine

number = SINH (number)

Hyperbolic sine

number = COS (number)

Cosine

number = COSH (number)

Hyperbolic cosine

number = TAN(number)

Tangent

number = TANH(number)

Cosine tangent

number = ASIN (number)

Arc sine

number = ACOS (number)

Arc cosine

number = ATAN (number)

Arc tangent

number = ATAN2 (number,number)

Arc tangent with two arguments

ATAN2 is an enhancement to ATAN and like that an inverse function of the angular function Tangent.

It takes two real numbers as argument, in contrary to the normal Arc Tangent, which only takes one number. In this way it has enough information to be able to return values in the full range of 360 degrees (meaning four quadrants) and is not restricted to two quadrants (as the normal Arc Tangent).

atan2(y,x) returns the angle θ between the ray to the point (x,y) and the positive x-axis, confined to (-Pi,Pi].

The result is returned in degree.

Changes text to number:

Example:

ATOF ('3.2') -> 3.2

LEN ('text')

LEN (Variable)

Length of text:

LEN('abcd')  = 4
LEN(VAR)  = Length of text in variable VAR

Section from text

The first parameter is the text, the second indicates at which symbol the extract begins, and the third parameter indicates the length of the extract.

Example:

SUBSTR('Hallo Welt',1,5) -> Hallo
SUBSTR('Hallo Welt',7,4) -> Welt

Used with threads:

Using the following expression you can generate different output.

Example:

NAME  =  GETTHREADTEXT(D,'DIN 13','',P,'NAME')

A detailed description can be found under Section 7.9.3.11.1.1.2, “Different pitches and derived automatic calculations for e.g. Row Label and Core diameter ”.

Compare the preceding function

GETTHREADTEXT gets a text from the table and GETTHREADVALUE a DOUBLE value.

text = TRANSLATE ('text')

TRANSLATE translates a text into the current language.

Also see Section 7.8.11.2, “ Translation functions” -> Example 1

text = TRANSLATE (VARIABLENNAME)

However, if in Row Label, Data sheet, 2D derivation, etc., the visible translated value shall be used, you can use the function "TRANSLATE(VARIABLENNAME)".

Also see Section 7.8.11.2, “ Translation functions” -> Example 2 and 3

text = $VARIABLENNAME(SRC=VALDESC).

Also see Section 7.8.11.2, “ Translation functions” -> Example 4