Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference REVERSEBYTE
Functions and Expressions Reference Guide
171
REVERSEBYTE
The REVERSEBYTE function reverses the byte order of an item.
Syntax
REVERSEBYTE (single-item-expression)
Meaning
REVERSEBYTE (item_to_reverse)
Returns
This function returns a single-item.
This function reverses the byte order of item_to_reverse.
Example
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.
Uses
Use
REVERSEBYTE when you need the bytes in the opposite sequence.