TRANSFORM( ) function

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

Syntax

TRANSFORM(original_string)

Parameters

original_string

Character. The character expression to reverse the order of bi-directional text for.

Output

Character.

Remarks

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.

Example

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



(C) 2015 ACL Services Ltd. All Rights Reserved.