Functions List (Magic xpi 4.5)

In Magic xpi, you can use functions as part of a condition or a formula for computing a value.

A function usually contains one or more arguments, delimited by commas. The arguments are enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date (). Every function returns a value. You can enter any arithmetic expression that follows conventional algebraic rules, or a string or a logical expression.

Operators can be numeric (for example, '+'), string (for example, '&'), or logical (for example, "NOT").

Functions can be nested to any level using parentheses. For example, the following expression gives the real length of the string stored in the variable A: Len(LTrim(RTrim(A))). Further complexity is possible by nesting logical expressions, including IF, AND, NOT, and OR. Magic xpi removes and superfluous parentheses.

A function usually contains one or more arguments, delimited by commas. The argument list is enclosed in parentheses. Even if the function contains no arguments it still requires a set of parentheses: for example, Date ().

Every function returns a value.

Text that is entered for ‘Alpha’ and ‘Blob’ expected output will automatically be surrounded by single apostrophes. For example, if you type some text and click the Verify button, Magic xpi will automatically change some text to 'some text'.

In the Expression Editor, each function has its own tooltip that describes its signature. You can also highlight a particular function in the list, and press F1 to access its Help page.

You can also add user-defined Magic xpa functions to Magic xpi. For more information, click here.

Note:

To check the syntax of the expression that you are working on, click the Verify button. All string functions can work with BLOBs. They can therefore be used with the Flow Data utility and with the Data Mapper. In all functions, the parameters should be of the type described or be evaluated to that type. For example, BlobToBase64(BLOB blob) can be used in the following ways: By setting a BLOB variable. For example, BlobToBase64(‘<?xml version="1.0" encoding="UTF-8"?>’). By an expression that is evaluated to a numeric value. For example, ABS(C.Name1) where C.Name1 is a BLOB variable.

 

The following is an alphabetical list of functions:

ABS ACOS AddDate AddTime ANSI2OEM ASCIIChr ASCIIVal ASIN AStr ATAN Blb2File BlobAddBOM BlobFromBase64 BlobSize BlobToBase64 BOM BOY CallPublic CASE CDOW ChkDgt ClientCertificateAdd ClientCertificateDiscard CMonth CONCAT Convert COS CRC Date DateTimeFormat Day DelSubStr DOW DStr DVal EnvVal EOM EOY EXP File2Blb FileExist Fill Fix Flip GetBPID GetDate

GetFlowID GetFSID GetLang GetObjectID GetObjectName GetSessionID GetTime GetTimeZone GetUniqueCounter Hour HStr HVal IF INIGet INIGetLn Ins InStr IsFlowEnabled ISNULL JSONElementExist Left Len LOG Logging Lower LTrim MAX MID MIN Minute MOD Month MStr mTime mTStr MVal NDOW NMonth NOT NULL objOldName ODSArrayCnt ODSExists ODSGet OEM2ANSI RAND

Range Rep RepStr Right Round RqHTTPHeader RqHTTPStatusCode RTrim Second SetHTTPHeaders SIN Str STRFormat StrToken StrTokenCnt StrTokenIdx TAN Time Translate TranslateNR Trim TStr TVal UDSClear UDSDeleteRecord UDSGet UDSGetField UDSSet UDSUpdateField UnicodeCHR UnicodeFromANSI UnicodeToANSI UnicodeVal Upper UTCDate UTCmTime UTCTime UTF8FromAnsi UTF8ToAnsi UTF8fromUnicode UTF8toUnicode Val XMLExist XMLStr XMLVal Year