Conversion Functions (Magic xpa 3.x)

ANSI2OEM – Converts data from ANSI to OEM.

ASCIIChr – Converts a number to a corresponding character in the ASCII character set.

ASCIIVal – Evaluates the leftmost character of an alphanumeric string and returns its value in the ASCII character set.

AStr – Applies a selected format to a string value.

Blb2File – Saves a BLOB object to a file.

ClientBlb2File – Saves a BLOB object to a file.

ClientFile2Blb – Moves a file into a BLOB variable.

DStr – Date-to-string conversion.

DVal – String-to-date conversion.

File2Blb – Saves a file to a BLOB object.

File2Ole – Moves a file to an OLE variable.

HStr – Converts decimal to hexadecimal.

HVal – Converts hexadecimal to decimal.

Lower – Returns a string in lowercase.

MStr – Converts number to alpha (any format).

mTStr – Converts a time value in milliseconds to a specified Alpha string picture format.

mTVal – Converts a time value in milliseconds from an Alpha string to a numeric value.

MVal – Converts alpha to number (any format).

OEM2ANSI – Converts data from OEM to ANSI.

TStr – Translate a time value to an alpha character.

TVal – Alpha to time conversion.

UnicodeChr – Converts a numeric value to its corresponding Unicode character.

UnicodeVal – Converts a Unicode character to its corresponding numeric value.

Upper – Converts lowercase letters to uppercase letters.

UTF8FromAnsi – Converts data encoded in ANSI to UTF8.

UTF8ToAnsi – Converts data encoded in UTF8 to an ANSI string. This function uses code pages defined in the CodePage function. If you are not using the CodePage function, the default OS code page is used in a similar way as with Java functions.

Val – Converts an Alpha character to a number.