TRANSFORM(original_string)
Character. The character expression to reverse the order of bi-directional text for.
Character.
You can use this function to adjust the display order of Arabic or Hebrew characters, so they display correctly. This function identifies bi-directional data and displays it correctly in the view, from right to left. All other characters display from left to right.
In the following example, the string “XYZ” represents Hebrew/bidirectional characters in a string that otherwise contains regular characters. The direction of the “XYZ” string is reversed, while the other characters are unmodified.
TRANSFORM("ABC ZYX 123")
returns “ABC XYZ 123”.