How to: |
The UFMT function converts characters in the source_string to their hexadecimal representation. This function is useful for examining data of unknown format. As long as you know the length of the data, you can examine its content.
UFMT(source_string, length, output_format)
where:
Alphanumeric
Is the string to convert.
Integer
Is the number of characters in the source_string.
Alphanumeric
The format of the output_format must be alphanumeric and its length must be twice the length of the source string.
UFMT converts each value in JOBCODE to its hexadecimal representation and stores it in a column with the format A6.
UFMT(JOBCODE, 3, 'A6')
For A01, the result is C1F0F1.
For A02, the result is C1F0F2.
iWay Software |