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 string 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.