Translate

The Translate function allows you to assign different results to several values of a variable. Within an argument, different values are separated by a semicolon[;].

Syntax :

Translate ('Attribut', 'Bedingung', 'Rückgabewert für Bedingung', 'optinaler Defaultwert')

caution: Only single quotation marks (ASCII) should be used. On the other hand, if you copy the quotation marks from a word processor, they correspond to the local Unicode character. With these Unicode quotes, the Translate mapping function does not work.

Sample

Translate(@BackOrder, 'true;false', 'X1;X2')

The return value of @BackOrder can be true or false. If it is true then X1 is output, if it is false then X2 is output.

Translate(@Wert, '1;2;3;4', 'A;B;C;D')

Here, the return value of @value can be 1,2,3 or 4. Correspondingly, A, B, C or D are output.