REVERSEBYTE

Use the REVERSEBYTE function when you need the bytes in the opposite sequence. REVERSEBYTE reverses the byte order of an item.

Syntax:
REVERSEBYTE (single-item-expression)
Meaning:
REVERSEBYTE (item_to_reverse)
Returns:
A single item

This function reverses the byte order of item_to_reverse.

Examples

  • REVERSEBYTE ("HI MOM!")

    Returns "!MOM IH"

  • RIGHT (FullName, FIND (" " , REVERSEBYTE (FullName)) - 1)

    If FullName is "Alyce N. Wunderland", the above example uses REVERSEBYTE to reverse the characters in FullName (resulting in "dnalrednuW .N ecylA"). Then, the FIND function is evaluated to locate the first space in the resultant string (between the "W" and the ".") that would result in a value of 11. Finally, the RIGHT function is evaluated to take the rightmost 10 (11-1) characters of FullName; providing the final result of "Wunderland".

Note: The examples are used for illustration only. Do not use this function with string literals.

Feedback