TRANSFORM( ) function

Reverses the display order of bi-directional text within a specified string.

Syntax

TRANSFORM(original_string)

Parameters

Name	Type	Description
original_string	character	The field, expression, or literal value containing bi-directional text.

Output

Character.

Examples

Basic examples

In the input string, the characters "XZQB" represent Hebrew/bidirectional characters in an input string that otherwise contains regular characters.

In the output string, the direction of "XZQB" is reversed, and returns "BQZX". The other characters are unmodified.

Returns "ABC BQZX 123":

TRANSFORM("ABC XZQB 123")

Remarks

How it works

The TRANSFORMS( ) function identifies bi-directional data and displays it correctly in the view, from right to left.

All other characters processed by the function are unmodified and continue to display from left to right.

When to use TRANSFORMS( )

Use TRANSFORMS( ) to adjust the display order of Arabic or Hebrew characters, so they display correctly.